Home » RDBMS Server » Performance Tuning » Creating SQL tuning set and how it will help (Oracle 10g)
Creating SQL tuning set and how it will help [message #361586] Thu, 27 November 2008 01:47 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Oracle 10g comes up with SQL TUNING ADVISOR feature. I have already use this feature to analyze sql one at a time. Lack of
privilege compells (ADMINISTER SQL TUNING SET privilege) me to put the question here..Can we use a bunch of SQL instead of running one statement at a time? I found that Tuning task can be created from an SQL tuning set.Want to know if anyone has use this feature for SQL tuning sets.



http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10752/sql_tune.htm


Thanks in adavance,

Oli

Report message to a moderator

Re: Creating SQL tuning set and how it will help [message #361619 is a reply to message #361586] Thu, 27 November 2008 03:27 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member
A bit of topic , but you know that you have to pay an extra fee for using SQL TUNING ADVISOR in Oracle Confused

Report message to a moderator

Re: Creating SQL tuning set and how it will help [message #361642 is a reply to message #361619] Thu, 27 November 2008 04:15 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Quote:

A bit of topic , but you know that you have to pay an extra fee for using SQL TUNING ADVISOR in Oracle



Nothing like that.

Report message to a moderator

Previous Topic: Contention
Next Topic: 'is Null' versus '='
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 18:53:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.