Avatar of jcob_l
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/rdbms/dest/stand/trace
[oracle@newmac trace]$
Oracle Database

Avatar of undefined
Last Comment
jcob_l

8/22/2022 - Mon
Steven Harris

Your question is unclear, can you rephrase?

Try to give us as much detail as possible.
ASKER
jcob_l

get the recent trace information..
David VanZandt

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?
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
jcob_l

This is what I want

ie,
find out the recent alert log file and tail -5