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 provides a number of enhancements to the Optimizer. Notable among them is the capability to transport SQL profiles between databases. This allows you to generate a SQL profile and SQL tuning sets in the production environment and transport them to the development and user acceptance database, just as you would transfer object statistics. SQL profiles can now be matched to SQL text with literals after they have been normalized into bind variables (somewhat similar to the effects of the CURSOR_SHARING initialization parameter). A new view, V_$SQL_STATS, can display, among other interesting tidbits, a LAST_ACTIVE_TIME column. SQL statistics are also updated once every five ...

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