| Trace Oracle Job Session using tkprof [message #209447] |
Thu, 14 December 2006 21:07  |
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 #209661 is a reply to message #209447] |
Sat, 16 December 2006 07:45  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
