This discussion is archived
1 Reply Latest reply: Aug 15, 2013 12:46 AM by DK2010 RSS

Audit Sessions

user13109564 Newbie
Currently Being Moderated

Is there a way where we can audit database session from a particular appilcations ?

For example : We need to audit Toad and SQL developer sessions .

  • 1. Re: Audit Sessions
    DK2010 Guru
    Currently Being Moderated

    Hi,

    Yes you can if you have audit Enable on Your database start from here :AUDIT

    If you only want to monitor toad,sql Developer session you can Query from v$session like  SELECT program   FROM v$session where program like 'TO%'

    you can write a trigger to monitor these sessions

     

    HTH

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points