Re: Monitor the sql and binding data

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 24 May 2001 12:37:04 -0700
Message-ID: <77e87b58.0105241137.3dc7f1d4@posting.google.com>

"Randall Roberts" <randall_at_filer.org.nospam> wrote in message news:<3b0c33a8_3_at_news.pcmagic.net>...
> If you want to see what SQL statements have been executed against the server
> using the variable you would
>
> SELECT sql_text
> FROM V$sqlarea
> WHERE sql_text LIKE '%:g_dname%';

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 Thu May 24 2001 - 14:37:04 CDT