Re: how to find missing sqltext in an event 10046 tracefile

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