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]$
jcob_lAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steven HarrisPresidentCommented:
Your question is unclear, can you rephrase?

Try to give us as much detail as possible.
0
jcob_lAuthor Commented:
get the recent trace information..
0
DavidSenior Oracle Database AdministratorCommented:
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?
0
slightwv (䄆 Netminder) Commented:
It depends on what you are tracing and how you have it set up.

Please provide what you did to trace what you are tracing.

That said: to get the last 5 lines from a file in unix:
tail -5 some_file_name

where some_file_name is the file you want the last 5 lines from.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jcob_lAuthor Commented:
This is what I want

ie,
find out the recent alert log file and tail -5
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.