Oracle Dynamic Display Log

1. View the log file location.

[email protected]>select inst_id,name,value from V$diag_info;

inst_id NAME VALUE
---------- -------------------- --------------------------------------------------
1 Diag Enabled TRUE
1 ADR base/u01/app/oracle
1 ADR Home/u01/app/oracle/diag/rdbms/prod/prod
1 Diag trace/u01/app/oracle/diag/rdbms/prod/prod/trace
1 Diag Alert/u01/app/oracle/diag/rdbms/prod/prod/alert
1 Diag incident/u01/app/oracle/diag/rdbms/prod/prod/incident
1 Diag cdump/u01/app/oracle/diag/rdbms/prod/prod/cdump
1 Health Monitor/u01/app/oracle/diag/rdbms/prod/prod/hm
1 Default Trace File/u01/app/oracle/diag/rdbms/prod/prod/trace/prod_or
A_4873.trc

1 Active problem Count 0
1 Active Incident Coun 0
T

The--alert folder is an XML file;

The--trace folder is a text file;

[Email protected] trace]$ pwd
/u01/app/oracle/diag/rdbms/prod/prod/trace
[Email protected] trace]$ ll-atl|grep alert*
-RW-R-----1 Oracle oinstall 99797 SEP 14:54 alert_prod.log
[Email protected] trace]$ tail-f alert_prod.log
Mon Sep 29 14:43:34 2014
Starting background Process SMCO
Mon Sep 29 14:43:34 2014
SMCO started with pid=28, OS id=4709
Mon Sep 29 14:54:57 2014
Thread 1 advanced to log sequence (LGWR switch)
Current log# 3 seq# mem# 0:/u01/app/oracle/oradata/prod/onlinelog/o1_mf_3_b22567o2_.log
Current log# 3 seq# mem# 1:/u01/app/oracle/fast_recovery_area/prod/onlinelog/o1_mf_3_b2256827_.log
Mon Sep 29 14:54:58 2014
Archived Log Entry 7 added for thread 1 sequence ID 0x102473b1 dest 1:

--Check the alert log under the operating system. with tail instructions;

If the database has any changes, the log file will produce corresponding records

For viewing learning tests it's best just

Oracle Dynamic Display Log