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



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


Current Time: Wed Dec 07 06:46:56 CST 2016

Total time taken to generate the page: 0.09438 seconds