Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger on v$sql catalog table
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
![]() |
![]() |