Oracle Audit: Why Logons are less than 0.1% of logoffs?

5 votes

1 answer

907 views

                          I see the following quantities of logins versus logoffs vs logoffs by cleanup in a database:

    SQL> select action_name, count(*) qty
    from Dba_audit_session
    group by action_name
    order by 1;  2    3    4
    
    ACTION_NAME                        QTY
    --------------------------- ----------
    LOGOFF                         1946180
    LOGOFF BY CLEANUP               754683
    LOGON                             1026


It doesn't make sense that logons are less than 0.1% of logoffs.


Any ideas why?

                        

Asked by RGO (423 rep)

Aug 20, 2015, 06:52 AM
Last activity: Feb 20, 2018, 10:48 AM

Oracle Audit: Why Logons are less than 0.1% of logoffs?

Related Questions