Here are some steps for extracting Oracle Trace File. This file is commonly used to analyze database performance/problem
Files are located on /$ORACLE_HOME/admin/$DB_NAME/udump
Trace file example
niaga_ora_13228.trc
niaga_ora_13379.trc
Extraction steps
$ cd /data/oracle/admin/niaga/udump
$ tkprof niaga_ora_13228.trc 13228.txt sys=no explain=niaga/niaga sort=prsela,exeela,fchela
The outout for above syntax will be 13228.txt
You can open 13228.txt using your own text editor
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment