Re: Bind variable values

"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: sfaroult_at_oriole.com

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: ListGuru_at_fatcity.com (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).