Home » RDBMS Server » Performance Tuning » SQL Tuning Advisor Feature (Oracle 10g)
SQL Tuning Advisor Feature [message #361269] Tue, 25 November 2008 10:52 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
I am trying to use one of the new feature in 10g ,SQL TUNING ADVISOR feature...But I am not finding any recommendations for bad sql as per the document.


Regards,
Oli

Report message to a moderator

Re: SQL Tuning Advisor Feature [message #361274 is a reply to message #361269] Tue, 25 November 2008 11:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe there is no bad SQL or there is no suitable recommendation.

Regards
Michel

Report message to a moderator

Re: SQL Tuning Advisor Feature [message #361275 is a reply to message #361274] Tue, 25 November 2008 11:38 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
For an sql, which is running in oracle 10g but performance is not good, by using this feature I am getting only this message: 
ORA-00900: invalid SQL statement


Regards,
Oli

Report message to a moderator

Previous Topic: How to avoid union?
Next Topic: Performance tuing using FIRST_ROWS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 00:43:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.