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 ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
