10046 trace file assistance
I am trying to understand what some of the information is in the trace file. We are hitting our cursor limit, the same sql is opening a new cursor for every parse. Why is there a close before the PARSING? Also the error is from the Package that calls the sql that keeps getting parsed. The package is only executed 1 time.
PARSING IN CURSOR #140151870527904 len=59 dep=0 uid=96 oct=47 lid=96 tim=1053769732992 hv=1864078789 ad='b1a75278' sqlid='3dd2c9prjr5f5'
Begin xxxx end;
end of stmt
PARSE #140151870527904:c=64,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=2,plh=0,tim=1053769732992