OraFAQ Forum: Performance Tuning » 11g sql tuning(urgent)

Home » RDBMS Server » Performance Tuning » 11g sql tuning(urgent) (11g,solaris9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

11g sql tuning(urgent) [message #446758]

Wed, 10 March 2010 05:07

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.

Report message to a moderator

Re: 11g sql tuning(urgent) [message #446762 is a reply to message #446758]

Wed, 10 March 2010 05:20

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: 11g sql tuning(urgent) [message #448202 is a reply to message #446758]

Sat, 20 March 2010 09:54

Kevin Meade
Messages: 2103
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

Report message to a moderator

Previous Topic:	Optimize the Query
Next Topic:	most accessed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 22:21:21 CDT 2024