Oracle如何动态显示日志？

1.查看日志文件位置；

ind_user@prod>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

 --alert目录为一个xml文件；

 --trace目录中为文本文件；

[oracle@jibo trace]$ pwd

/u01/app/oracle/diag/rdbms/prod/prod/trace

[oracle@jibo trace]$ ll -atl|grep alert*

-rw-r-----  1 oracle oinstall 99797 sep 29 14:54 alert_prod.log

[oracle@jibo 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 12 (lgwr switch)

  current log# 3 seq# 12 mem# 0: /u01/app/oracle/oradata/prod/onlinelog/o1_mf_3_b22567o2_.log

  current log# 3 seq# 12 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 11 id 0x102473b1 dest 1:

--操作下查看alert日志，用tail指令；

有什么改动，日志文件就会产生相应的记录

用于查看学习测试最好不过