Results 1 to 2 of 2

Thread: Audit trail

  1. #1
    Join Date
    Dec 2001
    Posts
    80

    Unanswered: Audit trail

    I would like to the SQL statement issued by every user, I know that I can trun on audit trail to do that (i.e. setting init. parameter audit_trail and issue SQL statement "audit" to turn on which item I need to monitor. However, it doesn't record the exact statement that tht user issued. Is there any Oracle tool helping me to keep track the whole SQL statement issued by the user? Thanks in advanced.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    dbms_system.set-sql_trace_in_session (sid,serial#,true)

    where sid, serial# als cols from v$session

    or dbms_trace for 10G

Posting Permissions

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