Understanding DBA_AUDIT_SESSION

From: Marcin <mwolski_at_poczta.fm>
Date: Wed, 30 Apr 2003 14:52:10 +0200
Message-ID: <b8ogrq$ssv$1@sunflower.man.poznan.pl>

Hi All,

How should I interpret results from DBA_AUDIT_SESSION:

select USERNAME, OS_USERNAME, to_char(timestamp,'DD-MM HH24:MI:SS') Timestamp, ACTION_NAME, to_char(LOGOFF_TIME,'DD-MM HH24:MI:SS') LOGOFF_TIME, RETURNCODE from DBA_AUDIT_SESSION where to_char(timestamp,'DD-MM')='30-04' order by Timestamp;

USERNAME                       TIMESTAMP
ACTION_NAME                 LOGOFF_TIME

RETURNCODE

------------------------------ ---------------------------------------------
------------------------------ --------------------------- -----------------
------------------------------------------------------
SCOTT                            30-04 09:04:12

LOGON
2002

SCOTT                            30-04 09:04:29
LOGOFF                      30-04 09:04:31
0
SCOTT                            30-04 09:10:00
LOGOFF                      30-04 09:10:08
0
SCOTT                            30-04 09:26:44
LOGOFF                      30-04 09:26:47
0
SCOTT                            30-04 09:29:50

LOGON
2002

SCOTT                            30-04 09:31:53
LOGOFF                      30-04 09:31:54
0
SCOTT                            30-04 09:32:58
LOGOFF                      30-04 09:33:02
0
SCOTT                            30-04 09:33:29
LOGOFF                      30-04 09:33:36
0
SCOTT                            30-04 09:40:00
LOGOFF                      30-04 09:40:10
0
SCOTT                            30-04 09:42:57
LOGOFF                      30-04 09:42:57
0
SCOTT                            30-04 09:42:58

LOGON
0

SCOTT                            30-04 09:44:07

LOGON
0

SCOTT                            30-04 09:45:03

LOGON
2002

SCOTT                            30-04 09:45:10
LOGOFF                      30-04 09:45:10
0
SCOTT                            30-04 09:49:23
LOGOFF                      30-04 09:49:24
                   0
SCOTT                            30-04 09:51:02
LOGOFF                      30-04 09:51:02
0
SCOTT                            30-04 09:52:53

LOGON
2002

SCOTT                            30-04 09:53:55
LOGOFF                      30-04 09:53:58
0
SCOTT                            30-04 10:00:00
LOGOFF                      30-04 10:00:00

And my question:
SCOTT                            30-04 09:04:12

LOGON
2002
User SCOTT logged in at 30-04 09:04:12, but what does it mean - RETURNCODE=2002??

SCOTT                            30-04 09:04:29
LOGOFF                      30-04 09:04:31

0
User SCOTT logged off at 30-04 09:10:08 or 30-04 09:10:00??? What is the relationship between these two values??

SCOTT                            30-04 09:42:57
LOGOFF                      30-04 09:42:57

0
Why these two timestamp values are the same?? (30-04 09:42:57 and 30-04 09:42:57)

mw Received on Wed Apr 30 2003 - 07:52:10 CDT