Historical of SQL Executed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Historical of SQL Executed

  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Historical of SQL Executed

    Hi!
    I have Oracle 9iR2 and i don't know how to do something.
    Is there a way to gather all the sql executed in a period of time by a particular user? For example, all queries that user 'JUAN' executed today between 13:00 and 14:00
    I searched in some views but i couldn't resolve it and google didn't help to much.
    Thank's in advance
    Juan

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Enable auditing

  3. #3
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44
    ya, u can find info with Auditing....

    u can go.......
    http://download-uk.oracle.com/docs/c...udit.htm#10459

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