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

In Oracle Database 10g Release 2, ADDM has been enhanced to make its analysis more accurate in the areas related to CPU, paging, and the cache areas of the database. As well, the scope of ADDM has itself been broadened to include more server components such as streams, AQ, RMAN, and RAC. The Resource Manager also has some hooks into ADDM and is expected to benefit from the self-management capability of these advisors. An AWR difference report is available that can be used to compare two pairs of snapshots so that the performance analyst can have a better understanding of what ADDM now shows and correlate the changes. AWR snapshots are also transportable between databases so you can run ADDM reports ...

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