1 Reply Latest reply on Aug 15, 2013 7:46 AM by DK2010

    Audit Sessions


      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


          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