|
[oracle-l]
||
[Date Prev]
[04-2006 Date Index]
[Date Next]
||
[Thread Prev]
[04-2006 Thread Index]
[Thread Next]
Re: how to find missing sqltext in an event 10046 tracefile
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: paul@xxxxxxxxxxxxx
- Date: Mon, 03 Apr 2006 19:34:15 +0200
select table_name
from dictionary
where table_name like 'V$%CURS%'
HTH
S Faroult
Paul van den Bogaard wrote:
All,
in a tracefile generated by setting event 10046 I often find references
to cursors that have no statement in this tracefile (no corresponding
'PARSING IN' line).
Assuming the database is still up and running (and perhaps the session
that corresponds to this tracefile still exists) how can I find the
sqltext that belongs to the cursornumber mentioned in the tracefile?
Thanks
Paul.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
|
