Home » RDBMS Server » Performance Tuning » 11g sql tuning(urgent) (11g,solaris9)
11g sql tuning(urgent) [message #446758] Wed, 10 March 2010 05:07 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
I have been assigned to tune 9i sql for 11g. Don't know where to start.Can you suggest some books or links that can help me tuning the 11g queries for the data mart.
Re: 11g sql tuning(urgent) [message #446762 is a reply to message #446758] Wed, 10 March 2010 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can start by the sticky post in this forum, then follow its links.
Once you'll complete this you will no more need us.

Regards
Michel
Re: 11g sql tuning(urgent) [message #448202 is a reply to message #446758] Sat, 20 March 2010 09:54 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
I would also ask the following:

is there something wrong with the sql under 9i that you think it runs slow and thus needs tuning in 9i? If not then aside from some special situations, there should be no tuning required for 11g.

Kevin
Previous Topic: Optimize the Query
Next Topic: most accessed
Goto Forum:
  


Current Time: Sat Dec 10 09:25:43 CST 2016

Total time taken to generate the page: 0.12725 seconds