1 Reply Latest reply: Aug 15, 2013 2:46 AM by DK2010 RSS

    Audit Sessions

    user13109564

      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

          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