Re: Q: how to find the value of bind varaiable

From: Mark D Powell <mark.powell_at_eds.com>
Date: 23 Apr 2002 06:30:09 -0700
Message-ID: <178d2795.0204230530.19a56223@posting.google.com>

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0204230245.658d34d1_at_posting.google.com>...
> tedchyn_at_yahoo.com (Ted Chyn) wrote in message news:<44a19320.0204222117.104d90a2_at_posting.google.com>...
> > Sir,
> > How to find the value of bind variable in memory associated with a session
> > without using sql trace ?
> >
> > thnx ted chyn
>
>
> No version of course.
> In 8i various v$ views exists. From the top of my head I only remember
> v$sql_bind_meta_data, but there are more, all with the word 'bind' in
> it.
> The dict view would typically contain all of them
>
>
> and oh yes
> 'Stop calling me SIR Marcie'
> Peppermint Patty in Charles Schulz long-running comic Peanuts
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA

Ted, Note - per the 8.1.6 version of the Reference Manual the bind views only show values for the querying session so if you want them for someone else's session I believe you will have to start a level 8 or 12 trace on the other session to capture them. I am unaware if this has changed in 9i.

HTH -- Mark D Powell -- Received on Tue Apr 23 2002 - 08:30:09 CDT