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: 25574
Registered: January 2009
Location: SoCal
Senior Member
ALTER SESSION SET SQL_TRACE=TRUE
Previous Topic: Performance problem when using Analytic Functions. Need Help !!!
Next Topic: Error during Merge Statment
Goto Forum:
  


Current Time: Sun Aug 20 21:55:05 CDT 2017

Total time taken to generate the page: 0.09074 seconds