Home » RDBMS Server » Performance Tuning » spreport - tuning paramters!  () 1 Vote
spreport - tuning paramters! [message #247502] Tue, 26 June 2007 02:47 Go to next message
rons
Messages: 18
Registered: June 2007
Location: Scottland
Junior Member
Hi,

Attaching a spreport, could anybody inform me what parameters can be tuned.

The query with the hash value 3613345008, executes in my toad within 10 minutes, but in discoverer it takes around 1 hour and sometimes even more.

Thanks in advance.

Ronald
Re: spreport - tuning paramters! [message #247504 is a reply to message #247502] Tue, 26 June 2007 02:52 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
I would trace both of them and check the plans in TK*Prof - they are bound to be different. OPTIMIZER_MODE is a likely explanation as to why you get different plans, although there are a number of other parameters (that are less likely to have been altered) that could affect the plan.

Ross Leishman
Re: spreport - tuning paramters! [message #247506 is a reply to message #247502] Tue, 26 June 2007 02:59 Go to previous messageGo to next message
rons
Messages: 18
Registered: June 2007
Location: Scottland
Junior Member
Hi,

I'll check 10046 event of both the processes.

Request you to have a look at the spreport also. Any suggestions!

Ronald.
Re: spreport - tuning paramters! [message #247530 is a reply to message #247502] Tue, 26 June 2007 04:41 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
There is no point looking at SPREPORT while you already know what is the problem.

Just tune the query.

Michael
Previous Topic: SQL tuning -- need help urgent
Next Topic: Fine Tune Insert Statement
Goto Forum:
  


Current Time: Fri Dec 02 12:39:05 CST 2016

Total time taken to generate the page: 0.10280 seconds