Home » RDBMS Server » Performance Tuning » check oracle job status
check oracle job status [message #316219] Thu, 24 April 2008 05:24 Go to next message
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Currently my oracle_job is running.
And i am facing performance issue.

How can i check that because of Oracle Job i am getting perfomramce problem not because of others?

Re: check oracle job status [message #316281 is a reply to message #316219] Thu, 24 April 2008 08:14 Go to previous messageGo to next message
Messages: 25579
Registered: January 2009
Location: SoCal
Senior Member
Which of the following have you tried & what were the results
Re: check oracle job status [message #316656 is a reply to message #316219] Sun, 27 April 2008 03:31 Go to previous message
Messages: 619
Registered: July 2006
Senior Member
1. Extract WHAT clause from DBA_JOBS view.
2. Run it as stand-alone PLSQL block with trace.
3. Format trace with TKPROF.
4. Look at tkprof report.

Previous Topic: How to tune a view using 3 big tables
Next Topic: How to check for Null values
Goto Forum:

Current Time: Wed Aug 23 10:35:13 CDT 2017

Total time taken to generate the page: 0.42806 seconds