"Hand, Michael T" wrote: > > Can the value used in bind variables be retrieved from V$ tables? The > reason I am interested is I'm trying to get use a subset of the SQL from > V$SQLTEXT from one 8.1.7 instance to run a comparative test on another > instance. However, most of the SQL contains bind variables. I checked out > V$SQL_BIND_DATA but a records had VALUE as NULL. > > Thanks, > Mike
Mike, Yes and no. The bind variables are not stored in the SGA, but in the private memory of your server so you cannot see those from another session (I have not checked with MTS, but in practice if you can 'see' only what comes from sessions you cannot pick ...). However, I have managed to catch them in triggers (so, catching bind variables coming from _MY_ session). It requires a bit of juggling with the X$, because there is a join for which you need a cursor number which is left out of the V$ views. It's probably simpler to use event 10046 and extract the values from the trace file. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
