Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Monitor the sql and binding data

Re: Monitor the sql and binding data

From: wy <wy_at_fudan.edu>
Date: 28 May 2001 19:17:04 -0700
Message-ID: <e8d0244c.0105281817.6cf9b152@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 Mon May 28 2001 - 21:17:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US