Re: Trigger on v$sql catalog table

From: Jim Kennedy <kennedy-down_with_spammers_at_comcast.net>
Date: Fri, 11 Jul 2003 00:41:27 GMT
Message-ID: <XInPa.27033$sY2.11722@rwcrnsc51.ops.asp.att.net>

Don't. Use auditing. What you are planning to do is a very bad idea. Use audit capabilities.
Jim
"db dude" <db_guy_2002_at_yahoo.com> wrote in message news:f4a8da28.0307101513.23c0f2ce_at_posting.google.com...
> Hi,
>
> Can anyone tell me what is the base table for public.v$sql. The DDL
> for v$sql points to v_$sql (which is again a view).
>
> I am interested in creating a trigger on the base table of
> public.v$sql to moniter sql queries.
Received on Thu Jul 10 2003 - 19:41:27 CDT