Hi all,
Oracle 11.2.0.3 x64 on Linux x64.
Non RAC.
I have a trace file (captured with binds=true, waits=true) where inside I have a huge number of obj# references for object which is not in the trace file mentioned anywhere.
Trace file part example :
...
PARSING IN CURSOR #22 len=52 dep=0 uid=46 oct=3 lid=46 tim=43179827168145 hv=1014772292 ad='c00000023baba230' sqlid='amqq2ncy7sck4'
select CTN from PF_TRX where (CTN=:b0 and ROWNUM=1)
END OF STMT
PARSE #22:c=0,e=17,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2442708035,tim=43179827168144
BINDS #22:
Bind#0
oacdty=01 mxl=32(25) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=01 csi=32 siz=32 off=0
kxsbbbfp=9fffffffbf5faba0 bln=32 avl=10 flg=05
value="0606015172"
EXEC #22:c=0,e=94,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2442708035,tim=43179827168314
WAIT #22: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=775422 tim=44216143020385
FETCH #22:c=0,e=13,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,plh=2442708035,tim=43179827168378
STAT #22 id=1 cnt=1 pid=0 pos=1 obj=0 op='COUNT STOPKEY (cr=2 pr=0 pw=0 time=0 us)'
STAT #22 id=2 cnt=1 pid=1 pos=1 obj=8236 op='INDEX RANGE SCAN PF_TRX_1IX (cr=2 pr=0 pw=0 time=0 us cost=1 size=11 card=1)'
WAIT #22: nam='SQL*Net message from client' ela= 135 driver id=1413697536 #bytes=1 p3=0 obj#=775422 tim=44216143020630
...
obj#=775422 is an index in one of mine user schema tables-not any kind of system related stuff.
But table, which own that indexes is never mentioned in the whole trace file (DDL, DML or Select statement).
TKPROF doesn't show as well no presence of that table.
How to interpret such an entries according that entries in mine case makes the biggest wait event.
Thx,
Damir