Oracle SQL Tuning


What are the enhancements from Oracle 9i to Oracle 10g considering the SQL Tuning process?
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
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:

In that doc be sure to check out: Automatic SQL Tuning.
pms_reddy1Author Commented:
Could you please give more details about those?
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.
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
slightwv (䄆 Netminder) Commented:
Wasn't Automatic SQL Tuning already mentioned?
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.