Re: Monitor the sql and binding data

It's common practice among DBAs to use the undocumented dbms_system.set_ev procedure as:

dbms_system.set_ev(<sid>, <serial#>, 10046, <level>, '');

where <level> should be at least 4.

"V$SQL_BIND_DATA gives you bind values for open cursors in the current session only." (Steve Adams).

Yong Huang
yong321_at_yahoo.com

wy_at_fudan.edu (wy) wrote in message news:<e8d0244c.0105281817.6cf9b152_at_posting.google.com>...
> I should make the problem more clearly, the sql I want to monitor is
> executing in another appliction instead of sqlplus, and I want to find
> out the value passed by application to sql.
> I think V$ views should help,but can not find any clues.
> > Could the new (8.1.7) v$sql_bind_data and v$sql_bind_metadata views be
> > used here?
> >
> > I looked at these (session-specific) views and couldnt see anything
> > interesting in them. Just a bunch of zeros.
> >
> > Has anyone used these v$ views?
Received on Tue May 29 2001 - 00:16:48 CDT