Professional Web Applications Themes

Trigger on v$sql catalog table - Oracle Server

Don't. Use auditing. What you are planning to do is a very bad idea. Use audit capabilities. Jim "db dude" <db_guy_2002> wrote in message news:f4a8da28.0307101513.23c0f2ceposting.google.c om... > 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....

  1. #1

    Default Re: Trigger on v$sql catalog table

    Don't. Use auditing. What you are planning to do is a very bad idea. Use
    audit capabilities.
    Jim
    "db dude" <db_guy_2002> wrote in message
    news:f4a8da28.0307101513.23c0f2ceposting.google.c om...
    > 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.

    Jim Kennedy Guest

  2. #2

    Default Re: Trigger on v$sql catalog table


    "db dude" <db_guy_2002> wrote in message news:f4a8da28.0307101513.23c0f2ceposting.google.c om...
    > 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


    Anurag Varma Guest

  3. #3

    Default Re: Trigger on v$sql catalog table


    "Anurag Varma" <avdbihotmail.com> wrote in message news:AVnPa.5036$Wp1.548news02.roc.ny...
    >
    > "db dude" <db_guy_2002> wrote in message news:f4a8da28.0307101513.23c0f2ceposting.google.c om...
    > > 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
    >
    >
    select * from V$FIXED_VIEW_DEFINITION where view_name = 'GV$SQL';
    The table name comes up as x$kglcursor

    ;) Now let me see if after all those warnings you still go ahead and try it.

    Anurag



    Anurag Varma Guest

Similar Threads

  1. Select Into and Trigger on Destination table....
    By Rog in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: April 16th, 05:29 PM
  2. Replies: 2
    Last Post: January 31st, 07:57 PM
  3. catalog
    By Reza Saheban webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 1
    Last Post: January 29th, 09:52 AM
  4. Replies: 2
    Last Post: August 12th, 07:55 AM
  5. sending an email from a table trigger (before inserting row)
    By Holger Baer in forum Oracle Server
    Replies: 10
    Last Post: July 7th, 02:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139