Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

knowing if sessions are auditing

chijarSep 26 2013 — edited Sep 27 2013

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

  7  from DBA_AUDIT_SESSION

  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

SQL>

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

many thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2013
Added on Sep 26 2013
2 comments
735 views