OraFAQ Forum: Performance Tuning » check oracle job status

Home » RDBMS Server » Performance Tuning » check oracle job status

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

check oracle job status [message #316219]

Thu, 24 April 2008 05:24

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Hi,
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?

Thanks,

Report message to a moderator

Re: check oracle job status [message #316281 is a reply to message #316219]

Thu, 24 April 2008 08:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Which of the following have you tried & what were the results
http://www.orafaq.com/forum/t/84315/74940/

Report message to a moderator

Re: check oracle job status [message #316656 is a reply to message #316219]

Sun, 27 April 2008 03:31

michael_bialik
Messages: 621
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.

HTH.

Report message to a moderator

Previous Topic:	How to check for Null values
Next Topic:	Costly update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:37:47 CST 2024