Home » RDBMS Server » Performance Tuning » Trace Oracle Job Session using tkprof
Trace Oracle Job Session using tkprof [message #209447] Thu, 14 December 2006 21:07 Go to next message
orasaket
Messages: 70
Registered: November 2006
Member
Hi,
i am using oracle 9i R2 on Linux
i am exeuting some procedures using oracle job
i want to trace the oracle job session for performance analysis

how can do this using tkprof?please explain

Thanks and Regards,
OraSaket
Re: Trace Oracle Job Session using tkprof [message #209467 is a reply to message #209447] Fri, 15 December 2006 00:37 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
./fa/1622/0/<= Click
Re: Trace Oracle Job Session using tkprof [message #209661 is a reply to message #209447] Sat, 16 December 2006 07:45 Go to previous messageGo to next message
orasaket
Messages: 70
Registered: November 2006
Member
Hi Ross,
i am not an expert to understand the abbreviation "RTFM"?
BTW let me explain what i am trying to do.

i am process large number of records e.g. insurance policies
since volume is large,we have created procedure which in turn will submit 16 jobs, each processing total records/16 no of records by calling another procedure.

for analyzing the performance i want to trace session for one of the 16 jobs submitted.

how can i do that?

Thanks and Regards,
OraSaket
Re: Trace Oracle Job Session using tkprof [message #209663 is a reply to message #209661] Sat, 16 December 2006 08:35 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Read The Fine Manual
Just click the image.
Previous Topic: Windows vs Linux
Next Topic: Shared Pool Advisory for Shared Pool Size
Goto Forum:
  


Current Time: Sun Dec 11 00:27:19 CST 2016

Total time taken to generate the page: 0.07953 seconds