O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

New Features in Oracle Database 10g Release 2

Oracle Database 10g Release 2 promises quite a few additions for SQL tuning. For example, the OEM has been enhanced to provide a better user experience and to expose more powerful features of the SQL Access Advisor. Recommendation and action implementation statuses are now available. In addition, SQL Access Advisor will be able to recommend function-based indexes. SQL profiles have also been enhanced to match SQL text with literal values by normalizing them into bind variables. As well, SQL profiles and SQL tuning sets are transportable across databases so you can easily test production scenarios in development instances.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required