10g New Features - Tip of the Day

The COMPATIBLE parameter in Oracle 10g is irreversible; once you set it, you cannot change its value to one that is less than a previous value. To lower the value, you need to perform a point-in-time recovery of the database.



AWR collects the following types of data:

a)Time model statistics that show the amount of time spent by each activity

b)Object statistics that determine access and usage of database segments (database feature usage)

c)Selected statistics from V$SYSSTAT and V$SESSTAT (wait classes)

d)SQL statements that are producing high load on the system

e)ASH, which represents the history of recent sessions activity sampled from
V$SESSION every second

f)Operating system statistics