Oracle SQL Tuning

Hi,

What are the enhancements from Oracle 9i to Oracle 10g considering the SQL Tuning process?
pms_reddy1Asked:
Who is Participating?
 
tdthoaConnect With a Mentor 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
0
 
slightwv (䄆 Netminder) 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.
0
 
pms_reddy1Author Commented:
Could you please give more details about those?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
slightwv (䄆 Netminder)Connect With a Mentor 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
0
 
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
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
0
 
slightwv (䄆 Netminder) Commented:
Wasn't Automatic SQL Tuning already mentioned?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.