Trying to locate a cursor with very little information
- From: Chen Shapira <cshapi@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Jul 2009 15:38:18 -0700
Hi Oracle-L,
I read a fragment of a trace file as it is being written to disk. One
of the lines I see is:
FETCH #2:c=0,e=854,p=0,cr=14,cu=0,mis=0,r=1,dep=0,og=1,tim=259898908178
Unfortunately, I don't have the "PARSE" line that opened cursor #2.
Where should I look to attempt to find the relevant cursor and SQL?
Obviously I don't have anything like sql address or hash value that
can be helpful when looking at v$sql or v$open_cursor.
Any ideas and clues will be appreciated :)
Chen Shapira
--
//www.freelists.org/webpage/oracle-l
Other related posts:
