Re: Trigger on v$sql catalog table

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 11 Jul 2003 00:54:56 GMT
Message-ID: <AVnPa.5036$Wp1.548@news02.roc.ny>

"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.

forget about it. Not possible. Don't even think about it. <insert_your_favorite_warning_here>

Anurag Received on Thu Jul 10 2003 - 19:54:56 CDT

This message: [ Message body ]
Next message: Anurag Varma: "Re: Trigger on v$sql catalog table"
Previous message: Anurag Varma: "Re: High Version count in V$SQLAREA"
In reply to: db dude: "Trigger on v$sql catalog table"
Next in thread: Anurag Varma: "Re: Trigger on v$sql catalog table"
Reply: Anurag Varma: "Re: Trigger on v$sql catalog table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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