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 collects additional statistics as compared to Release 1. AWR now includes a collection of streams-specific performance data in a set of tables prefixed by WRH$STREAMS_ to assist in detecting streams-related issues. As well, additional information is collected in order to determine the efficacy and usage of SQL tuning sets. Other changes include a new AWR table named WRH$_COMP_IOSTAT that seems to catergorize and record different types of I/O.

Changes have also been made in the area of metrics reporting. OEM now computes statistical alert thresholds using either static (user-defined) or dynamic (self-adjusting) baselines. Dynamic baselining can significantly improve the ...

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