Database Tuning (MOSC)

MOSC Banner

appears to be extra exec and fetch lines in a trace file

edited Dec 26, 2010 7:14PM in Database Tuning (MOSC) 2 commentsAnswered
 Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning and Real Application Clusters options

Is a RAC db running on Linux

Here is an example of what I c in a trace file. The same pattern is repeated for select statements. wondering if it is a bug

PARSING IN CURSOR #3 len=92 dep=0 uid=65 oct=3 lid=59 tim=1293043649404910 hv=4211595418 ad='c5cf71a8' sqlid='0auyf4mxhgq4u'
select ln_serv_nbr from loan where ln_rsca_id = '9876543212' and rsca_co_id in ('LMS','CRE')
END OF STMT
PARSE #3:c=2999,e=10450,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=2539965424,tim=1293043649404910

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