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
Messages: 95
Registered: May 2006
Location: KOLKATA
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: 65088
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.

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: 2102
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.

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

Current Time: Tue Jul 25 22:06:30 CDT 2017

Total time taken to generate the page: 0.08295 seconds