jcob_l
asked on
trace
How will I find from this info the last five lines of the recent file..
What happended to the trace file recently..
From the os level
and oracle leve
I mean command
[oracle@newmac trace]$ ls -lrt
total 256
-rw-r----- 1 oracle oinstall 444 Sep 1 23:01 stand_ora_19917.trm
-rw-r----- 1 oracle oinstall 26114 Sep 1 23:01 stand_ora_19917.trc
-rw-r----- 1 oracle oinstall 258 Sep 2 11:53 stand_ora_2040.trm
-rw-r----- 1 oracle oinstall 14431 Sep 2 11:53 stand_ora_2040.trc
-rw-r----- 1 oracle oinstall 60 Sep 2 11:54 stand_mman_2112.trm
-rw-r----- 1 oracle oinstall 821 Sep 2 11:54 stand_mman_2112.trc
-rw-r----- 1 oracle oinstall 3932 Sep 3 08:16 stand_vktm_2098.trm
-rw-r----- 1 oracle oinstall 50439 Sep 3 08:16 stand_vktm_2098.trc
-rw-r----- 1 oracle oinstall 79 Sep 7 13:49 stand_vktm_5198.trm
-rw-r----- 1 oracle oinstall 1081 Sep 7 13:49 stand_vktm_5198.trc
-rw-r----- 1 oracle oinstall 257 Sep 7 13:49 stand_ora_5155.trm
-rw-r----- 1 oracle oinstall 14431 Sep 7 13:49 stand_ora_5155.trc
-rw-r----- 1 oracle oinstall 225 Sep 7 13:49 stand_m000_5249.trm
-rw-r----- 1 oracle oinstall 3302 Sep 7 13:49 stand_m000_5249.trc
-rw-r----- 1 oracle oinstall 395 Sep 7 13:49 stand_ckpt_5218.trm
-rw-r----- 1 oracle oinstall 1707 Sep 7 13:49 stand_ckpt_5218.trc
-rw-r----- 1 oracle oinstall 60 Sep 7 13:49 stand_mman_5212.trm
-rw-r----- 1 oracle oinstall 821 Sep 7 13:49 stand_mman_5212.trc
-rw-r----- 1 oracle oinstall 60 Sep 7 13:49 stand_ora_5233.trm
-rw-r----- 1 oracle oinstall 866 Sep 7 13:49 stand_ora_5233.trc
-rw-r----- 1 oracle oinstall 257 Sep 7 13:50 stand_ora_5300.trm
-rw-r----- 1 oracle oinstall 14431 Sep 7 13:50 stand_ora_5300.trc
-rw-r----- 1 oracle oinstall 240 Sep 7 13:50 stand_m000_5390.trm
-rw-r----- 1 oracle oinstall 3274 Sep 7 13:50 stand_m000_5390.trc
-rw-r----- 1 oracle oinstall 394 Sep 7 13:50 stand_ckpt_5365.trm
-rw-r----- 1 oracle oinstall 1707 Sep 7 13:50 stand_ckpt_5365.trc
-rw-r----- 1 oracle oinstall 60 Sep 7 13:50 stand_mman_5359.trm
-rw-r----- 1 oracle oinstall 821 Sep 7 13:50 stand_mman_5359.trc
-rw-r----- 1 oracle oinstall 89 Sep 7 13:53 stand_vktm_5343.trm
-rw-r----- 1 oracle oinstall 1173 Sep 7 13:53 stand_vktm_5343.trc
-rw-r----- 1 oracle oinstall 109 Sep 7 13:53 stand_ora_5387.trm
-rw-r----- 1 oracle oinstall 1420 Sep 7 13:53 stand_ora_5387.trc
-rw-r----- 1 oracle oinstall 13157 Sep 7 13:53 alert_stand.log
[oracle@newmac trace]$ pwd
/oracle/app/oracle/diag/rd
[oracle@newmac trace]$
What happended to the trace file recently..
From the os level
and oracle leve
I mean command
[oracle@newmac trace]$ ls -lrt
total 256
-rw-r----- 1 oracle oinstall 444 Sep 1 23:01 stand_ora_19917.trm
-rw-r----- 1 oracle oinstall 26114 Sep 1 23:01 stand_ora_19917.trc
-rw-r----- 1 oracle oinstall 258 Sep 2 11:53 stand_ora_2040.trm
-rw-r----- 1 oracle oinstall 14431 Sep 2 11:53 stand_ora_2040.trc
-rw-r----- 1 oracle oinstall 60 Sep 2 11:54 stand_mman_2112.trm
-rw-r----- 1 oracle oinstall 821 Sep 2 11:54 stand_mman_2112.trc
-rw-r----- 1 oracle oinstall 3932 Sep 3 08:16 stand_vktm_2098.trm
-rw-r----- 1 oracle oinstall 50439 Sep 3 08:16 stand_vktm_2098.trc
-rw-r----- 1 oracle oinstall 79 Sep 7 13:49 stand_vktm_5198.trm
-rw-r----- 1 oracle oinstall 1081 Sep 7 13:49 stand_vktm_5198.trc
-rw-r----- 1 oracle oinstall 257 Sep 7 13:49 stand_ora_5155.trm
-rw-r----- 1 oracle oinstall 14431 Sep 7 13:49 stand_ora_5155.trc
-rw-r----- 1 oracle oinstall 225 Sep 7 13:49 stand_m000_5249.trm
-rw-r----- 1 oracle oinstall 3302 Sep 7 13:49 stand_m000_5249.trc
-rw-r----- 1 oracle oinstall 395 Sep 7 13:49 stand_ckpt_5218.trm
-rw-r----- 1 oracle oinstall 1707 Sep 7 13:49 stand_ckpt_5218.trc
-rw-r----- 1 oracle oinstall 60 Sep 7 13:49 stand_mman_5212.trm
-rw-r----- 1 oracle oinstall 821 Sep 7 13:49 stand_mman_5212.trc
-rw-r----- 1 oracle oinstall 60 Sep 7 13:49 stand_ora_5233.trm
-rw-r----- 1 oracle oinstall 866 Sep 7 13:49 stand_ora_5233.trc
-rw-r----- 1 oracle oinstall 257 Sep 7 13:50 stand_ora_5300.trm
-rw-r----- 1 oracle oinstall 14431 Sep 7 13:50 stand_ora_5300.trc
-rw-r----- 1 oracle oinstall 240 Sep 7 13:50 stand_m000_5390.trm
-rw-r----- 1 oracle oinstall 3274 Sep 7 13:50 stand_m000_5390.trc
-rw-r----- 1 oracle oinstall 394 Sep 7 13:50 stand_ckpt_5365.trm
-rw-r----- 1 oracle oinstall 1707 Sep 7 13:50 stand_ckpt_5365.trc
-rw-r----- 1 oracle oinstall 60 Sep 7 13:50 stand_mman_5359.trm
-rw-r----- 1 oracle oinstall 821 Sep 7 13:50 stand_mman_5359.trc
-rw-r----- 1 oracle oinstall 89 Sep 7 13:53 stand_vktm_5343.trm
-rw-r----- 1 oracle oinstall 1173 Sep 7 13:53 stand_vktm_5343.trc
-rw-r----- 1 oracle oinstall 109 Sep 7 13:53 stand_ora_5387.trm
-rw-r----- 1 oracle oinstall 1420 Sep 7 13:53 stand_ora_5387.trc
-rw-r----- 1 oracle oinstall 13157 Sep 7 13:53 alert_stand.log
[oracle@newmac trace]$ pwd
/oracle/app/oracle/diag/rd
[oracle@newmac trace]$
Last Comment
ASKER
get the recent trace information..
The most recent activity, according to your dump, would obviously be from the 7th. You can view the alert log, of course, but to read the stand_ora_5387.trc file you should use the TKPROF utility. There are many searchable examples of how to do that, one example is:
http://www.orafaq.com/wiki/SQL_Trace
Does that answer your question, I hope?
http://www.orafaq.com/wiki/SQL_Trace
Does that answer your question, I hope?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This is what I want
ie,
find out the recent alert log file and tail -5
ie,
find out the recent alert log file and tail -5
Oracle Database
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Try to give us as much detail as possible.