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

Trigger on v$sql catalog table

From: db dude <db_guy_2002_at_yahoo.com>
Date: 10 Jul 2003 16:13:17 -0700
Message-ID: <f4a8da28.0307101513.23c0f2ce@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 - 18:13:17 CDT

Original text of this message

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