Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> how to find missing sqltext in an event 10046 tracefile

how to find missing sqltext in an event 10046 tracefile

From: Paul van den Bogaard <paul_at_vdbogaard.com>
Date: Mon, 03 Apr 2006 19:17:15 +0200
Message-ID: <4431589B.6010600@vdbogaard.com> 





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


Received on Mon Apr 03 2006 - 12:17:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US