oracle trace 文件名,【方法整理】Oracle 获取trace跟踪文件名的几种常用方式

SYS@lhrdb>alter system dump datafile 1 block 380313;

System altered.

SYS@lhrdb>show parameter user_dump_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

user_dump_dest                       string      /oracle/app/oracle/diag/rdbms/

lhrdb/lhrdb/trace

SYS@lhrdb>! ls -lrt /oracle/app/oracle/diag/rdbms/lhrdb/lhrdb/trace/*.trc | tail -n 5

-rw-r-----    1 oracle   asmadmin      34143 Sep 27 13:00 /oracle/app/oracle/diag/rdbms/lhrdb/lhrdb/trace/lhrdb_m001_15859814.trc

-rw-r-----    1 oracle   asmadmin      49356 Sep 27 14:00 /oracle/app/oracle/diag/rdbms/lhrdb/lhrdb/trace/lhrdb_m001_15728766.trc

-rw-r-----    1 oracle   asmadmin      19089 Sep 27 15:00 /oracle/app/oracle/diag/rdbms/lhrdb/lhrdb/trace/lhrdb_m001_28377292.trc

-rw-r-----    1 oracle   asmadmin      32115 Sep 27 15:04 /oracle/app/oracle/diag/rdbms/lhrdb/lhrdb/trace/lhrdb_mmon_21233818.trc

-rw-r-----    1 oracle   asmadmin      21278 Sep 27 15:05 /oracle/app/oracle/diag/rdbms/lhrdb/lhrdb/trace/lhrdb_ora_19660944.trc