Oracle SQL Tuning

pms_reddy1
pms_reddy1 used Ask the Experts™
on
Hi,

What are the enhancements from Oracle 9i to Oracle 10g considering the SQL Tuning process?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
There are a lot of new Advisors.  I also beleive Automatic Memory Management was new in 10g.

The New Features doc is the best place to start:
http://docs.oracle.com/cd/B19306_01/server.102/b14214/chapter1.htm

In that doc be sure to check out: Automatic SQL Tuning.

Author

Commented:
Could you please give more details about those?
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>Could you please give more details about those?

About which?

Everything is in the docs.  Just use the doc search for those terms.

http://www.oracle.com/pls/db102/portal.portal_db?selected=2
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

David VanZandtOracle Database Administrator III
Commented:
Regretfully perhaps, but it's time to RTFM as recommended.  Two factoids I found useful were that the CHOOSE hint was dropped as the CBO default; and that STATSPACK was replaced with the automated workload repository (AWR). E-E and Metalink also have tons of previously asked questions about tuning.  HTH
Commented:
SQL Profiles is a new feature from 10g which is managed by Oracle Enterprise Manager as part of the Automatic SQL Tuning process. Apart from OEM, SQL Profiles can be managed through the DBMS_SQLTUNE package
http://www.oracle-base.com/articles/10g/automatic-sql-tuning-10g.php
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Wasn't Automatic SQL Tuning already mentioned?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial