Home » RDBMS Server » Performance Tuning » Performance Slow - Jobs
Performance Slow - Jobs [message #257244] Tue, 07 August 2007 20:36 Go to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hi all,

If I need to findout the jobs or sql query which takes long time how I need to findout the entire history that the job which is taking more time and cost.

ie, Which Data Dictionary view will provide me the entire result. Apart from any views Is there any other way to sort out the same.

This Question was asked on an Interview.

Please explain?

Thanks and Regards,
Prashanth
Re: Performance Slow - Jobs [message #257245 is a reply to message #257244] Tue, 07 August 2007 20:56 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
ALTER SESSION SET SQL_TRACE=TRUE
Previous Topic: Performance tunning
Next Topic: reverse key index
Goto Forum:
  


Current Time: Sun Dec 04 16:50:21 CST 2016

Total time taken to generate the page: 0.07956 seconds