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

Report message to a moderator

Re: Performance Slow - Jobs [message #257245 is a reply to message #257244] Tue, 07 August 2007 20:56 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ALTER SESSION SET SQL_TRACE=TRUE

Report message to a moderator

Previous Topic: Performance tunning
Next Topic: reverse key index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 05:57:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.