Re: Monitor the sql and binding data

could you tell me where to find the help about dbms_system.set_ev or how to use it?

thanks in advance.

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0105282116.43138072_at_posting.google.com>...
> 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 - 21:34:40 CDT