Oracle trace files & awrrpt report

-rw-r—– 1 oracle oinstall 61 Oct 4 16:00 ora11g_m000_8094.trm
-rw-r—– 1 oracle oinstall 917 Oct 4 16:00 ora11g_m000_8094.trc
-rw-r—– 1 oracle oinstall 62 Oct 4 16:07 ora11g_ora_23816.trm
-rw-r—– 1 oracle oinstall 7149 Oct 4 16:07 ora11g_ora_23816.trc
-rw-r—– 1 oracle oinstall 62 Oct 4 16:22 ora11g_ora_22325.trm
-rw-r—– 1 oracle oinstall 7516 Oct 4 16:22 ora11g_ora_22325.trc
-rw-r—– 1 oracle oinstall 62 Oct 4 16:52 ora11g_ora_19495.trm
-rw-r—– 1 oracle oinstall 7636 Oct 4 16:52 ora11g_ora_19495.trc
-rw-r—– 1 oracle oinstall 63 Oct 4 18:00 ora11g_m002_31314.trm
-rw-r—– 1 oracle oinstall 1347 Oct 4 18:00 ora11g_m002_31314.trc
-rw-r—– 1 oracle oinstall 164 Oct 4 18:32 ora11g_pmon_3298.trm
-rw-r—– 1 oracle oinstall 1902 Oct 4 18:32 ora11g_pmon_3298.trc
-rw-r—– 1 oracle oinstall 242 Oct 4 18:32 ora11g_smon_3340.trm
-rw-r—– 1 oracle oinstall 2153 Oct 4 18:32 ora11g_smon_3340.trc
-rw-r—– 1 oracle oinstall 5289189 Oct 4 19:44 alert_ora11g.log

servername:/oracle/app/diag/rdbms/ora11g/ora11g/trace #

as Oracle execute
@?/rdbms/admin/awrrpt.sql

/oracle/app/product/11g/db/rdbms/admin/awrrpt.sql

awrrp report sample
/home/oracle/awrrpt_1_10126_10127.html
/home/oracle/awrrpt_1_9962_9969.html

Advertisements