This discussion is archived
2 Replies Latest reply: Sep 27, 2013 5:16 PM by chijar RSS

knowing if sessions are auditing

chijar Newbie
Currently Being Moderated

Hi guys,

os: solaris 10 X86

db: RAC 11g r2



In my db I have:


audit_trail                          string      DB, EXTENDED


So, I know that audit is in ON but when I query to dba_audit_session only showed me records until the last June.

For July until now, I don't have any records refering to SESSIONS.


SQL> select OS_Username Usuario_SO,

  2    Username Usuario_Oracle, Terminal ID_Terminal,

  3    DECODE (Returncode, '0', 'Conectado', '1005', 'Fallo - Null',

  4    1017, 'Fallo', Returncode) Tipo_Suceso,

  5    TO_CHAR(Timestamp, 'DD-MM-YY HH24:MI:SS') Hora_Inicio_Sesion,

  6    TO_CHAR(Logoff_Time, 'DD-MM-YY HH24:MI:SS') Hora_Fin_Sesion


  8  where

  9  (TIMESTAMP between (to_date(to_char('01072013 18:00:00'),'ddmmyyyy HH24:MI:SS'))

10      and (to_date(to_char('30082013 23:59:00'),'ddmmyyyy HH24:MI:SS')));



no rows selected




Where can I located if audit for sessions in my databases was deactivated sice July ??

many thanks.

  • 1. Re: knowing if sessions are auditing
    DK2010 Guru
    Currently Being Moderated



    You can Query from following views to know what auditing is enable on your system






    In 11g there is option like audit/noaudit command to run after setting the parameter values.

    For more detail you can also check the doc:Verifying Security Access with Auditing



  • 2. Re: knowing if sessions are auditing
    chijar Newbie
    Currently Being Moderated

    thanks for your response Dk

    but in those views I cannot view anything about AUDIT SESSIONS in the database.

    The link describes those views as:


    Describes current system privileges being audited across the system and by user


    Describes current statement auditing options across the system and by user

    and when I query to those views they show me object privileges.


    Exists another view to see records for audit session option?


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