Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 
HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

 
   
 

DBA_AUDIT_SESSION view tips

Oracle Tips by Burleson Consulting

DBA_AUDIT_SESSION

<< Return to the index

Oracle 11g makes the following comments about the DBA_AUDIT_SESSION table: "All audit trail records concerning CONNECT and DISCONNECT"

Related notes on DBA_AUDIT_SESSION:

Column description of the DBA_AUDIT_SESSION view:

LOGOFF_DLOCK
No comments exist for the LOGOFF_DLOCK column of the DBA_AUDIT_SESSION table.
SESSIONID
No comments exist for the SESSIONID column of the DBA_AUDIT_SESSION table.
RETURNCODE
No comments exist for the RETURNCODE column of the DBA_AUDIT_SESSION table.
CLIENT_ID
No comments exist for the CLIENT_ID column of the DBA_AUDIT_SESSION table.
SESSION_CPU
No comments exist for the SESSION_CPU column of the DBA_AUDIT_SESSION table.
EXTENDED_TIMESTAMP
No comments exist for the EXTENDED_TIMESTAMP column of the DBA_AUDIT_SESSION table.
PROXY_SESSIONID
No comments exist for the PROXY_SESSIONID column of the DBA_AUDIT_SESSION table.
GLOBAL_UID
No comments exist for the GLOBAL_UID column of the DBA_AUDIT_SESSION table.
INSTANCE_NUMBER
No comments exist for the INSTANCE_NUMBER column of the DBA_AUDIT_SESSION table.
OS_PROCESS
No comments exist for the OS_PROCESS column of the DBA_AUDIT_SESSION table.
OS_USERNAME
No comments exist for the OS_USERNAME column of the DBA_AUDIT_SESSION table.
USERNAME
No comments exist for the USERNAME column of the DBA_AUDIT_SESSION table.
USERHOST
No comments exist for the USERHOST column of the DBA_AUDIT_SESSION table.
TERMINAL
No comments exist for the TERMINAL column of the DBA_AUDIT_SESSION table.
TIMESTAMP
No comments exist for the TIMESTAMP column of the DBA_AUDIT_SESSION table.
ACTION_NAME
No comments exist for the ACTION_NAME column of the DBA_AUDIT_SESSION table.
LOGOFF_TIME
No comments exist for the LOGOFF_TIME column of the DBA_AUDIT_SESSION table.
LOGOFF_LREAD
No comments exist for the LOGOFF_LREAD column of the DBA_AUDIT_SESSION table.
LOGOFF_PREAD
No comments exist for the LOGOFF_PREAD column of the DBA_AUDIT_SESSION table.
LOGOFF_LWRITE
No comments exist for the LOGOFF_LWRITE column of the DBA_AUDIT_SESSION table.

DBA_AUDIT_SESSION View Source

Oracle 11g's data dictionary defines the DBA_AUDIT_SESSION view using the following source query:

select os_username, username, userhost, terminal, timestamp, action_name,
logoff_time, logoff_lread, logoff_pread, logoff_lwrite, logoff_dlock,
sessionid, returncode, client_id, session_cpu, extended_timestamp,
proxy_sessionid, global_uid, instance_number, os_process
from dba_audit_trail
where action between 100 and 102

 
If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

 

 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

 
  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book
 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 
   

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.