Home » RDBMS Server » Performance Tuning » Query Performance trace (Oracle 10g,)
Query Performance trace [message #464911] Sat, 10 July 2010 11:21 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
All Oracle gurus ,

I have one report which have dynamic run time, It runs some times in 2 hrs which other days it takes 10-12 hrs. Do you see any reason for this, or what way I should be investigating and where?

Sessions Log/tables, please guide me through


Thanks,
Freakabhi

Report message to a moderator

Re: Query Performance trace [message #464913 is a reply to message #464911] Sat, 10 July 2010 11:54 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Thread: HOW TO: Post a SQL statement tuning request - template posting
http://forums.oracle.com/forums/thread.jspa?threadID=863295

Report message to a moderator

Previous Topic: SQL Query Help
Next Topic: SQL statment running for ever
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 05:27:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.