Database Tuning (MOSC)

MOSC Banner

10046 trace file assistance

edited Nov 14, 2019 2:54PM in Database Tuning (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center