You should set event 10046 - this is like sql_trace=true ... it'll generate
a trace file in udump that'll contain the sql statements and
extra info depending on the level of the event :
setting this event to level 4 : bind variables are included
setting this event to level 8 : wait events are included
setting the event to level 12 : bind AND waits are included
"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message
news:580389f07e50c4107cc8025a8bcf16ff.38849_at_mygate.mailgate.org...
> I can easily enough determine a currently running sql statement by
querying
> V$SQL_AREA/SESSION etc., but is there a way to find out the values of the
bind
> variables that the statement is currently using?
>
> This is version 8.1.6
>
> Thanks.
>
>
> --
> Posted from [65.193.99.4]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Wed Nov 21 2001 - 13:17:35 CST
