oracle audit trail views

Oracle Log View one. Path to Oracle log: Login: Sqlplus "/as sysdba" View path:sql> select * from V$logfile; Sql> select * from V$logfile; (#日志文件路径) two. What does the Oracle log file contain: (the number of logs may be slightly different) Control01.ctl example01.dbf redo02.log sysaux01.dbf undotbs01.dbf control02.ctl . log system01.dbf users01.dbf control03.ctl

☆dba_ opening .....Dba_users Database user InformationDba_segments Table Segment InformationDba_extents Data Area InformationDba_objects Database object InformationDba_tablespaces database table Space informationDba_data_files Data File setup InformationDba_temp_files Temporary data file informationDba_rollback_segs Rollback Segment InformationDba_ts_quotas User table Space quota informationDba_free_space Database Free Space informationDba_profiles Database User Resource limit informationDba_sys

throughout instance lifetime);serial#: The session sequence number, which is used to uniquely identify a session when one session ends and another session reuses the SID for that session;Audsid: Audit session ID, you can query the current session by Audsid Sid,select SID from V$session where Audsid=userenv (' SessionID ');paddr: Process Address, association v$process addr field, through this can query to process corresponding session;user#: The user#