I learned with oradebug ...
Example:
$ mv orcl_lgwr_14604.trc orcl_lgwr_14604.trc.old
$ ls -la *14604*
-rw-r----- 1 oracle oinstall 18764 Jul 13 22:38 orcl_lgwr_14604.trc.old
SQL> oradebug help
CLOSE_TRACE Close trace file
SQL> oradebug setospid 14604
Oracle pid: 6, Unix process pid: 14604, image: oracle@oratest (LGWR)
SQL> oradebug close_trace
Statement processed.
SQL> oradebug TRACEFILE_NAME
/u01/app/oracle/admin/orcl/bdump/orcl_lgwr_14604.trc
SQL> !ls -la *14604*
-rw-r----- 1 oracle oinstall 679 Jul 14 18:02 orcl_lgwr_14604.trc
-rw-r----- 1 oracle oinstall 18948 Jul 14 18:01 orcl_lgwr_14604.trc.old
No comments:
Post a Comment