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: Trigger on v$sql catalog table

Re: Trigger on v$sql catalog table

From: dias <ydias_at_hotmail.com>
Date: 11 Jul 2003 03:20:55 -0700
Message-ID: <55a68b47.0307110220.4b25250f@posting.google.com>


Hi,

What do you exactly want to achieve by monitoring sql queries ?

Dias

db_guy_2002_at_yahoo.com (db dude) 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 Fri Jul 11 2003 - 05:20:55 CDT

Original text of this message

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