find who/when sql statement was issued
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: find who/when sql statement was issued

  1. #1
    Join Date
    Nov 2000
    Posts
    172
    Hi everyone,

    Trying to find out how I can tell who and when a particular sql statement was issued. I realize 8i has the log miner. But I am running 8.0.5, how to accomplish this before 8i log miner?

    Thanks in advance,
    Kathy

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    You might be able to find it in V$SQL

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Enable Auditing
    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    both are right. Auditing will add perfomance overhead, check out in V$SQL DPT
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  5. #5
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Does V$SQL contain the full SQL text? cause the text field is only vc2(1000);
    There Nothing You cannot Do, The problem is HOW.

  6. #6
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    is so then check out v$sqltext table
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

Posting Permissions

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



Click Here to Expand Forum to Full Width