+ Reply to Thread
Results 1 to 3 of 3
  1. 07-23-2007 04:38 PM #1
    jbarreira
    jbarreira is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 07-23-2007 04:42 PM #2
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Enable auditing
    Reply With Quote Reply With Quote
  3. 07-24-2007 02:05 AM #3
    liakat's Avatar
    liakat
    liakat is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

Forum Rules

 Click Here to Expand Forum to Full Width