Automatic System Resource Management AWR Memory Statistics v$sysstat v$sesstat OS Statistics CPU Memory v$osstat Wait Classes v$event

We are top for USA Oracle Training Clients

Oracle support

Custom Oracle Training

Oracle Tips by Burleson

Easy Oracle Automation
Chapter 6 - Automatic System Resource Management

Guru Conversation for the Senior DBA

AWR in Memory Statistics

Some system and session statistics are stored in v$sysstat and v$sesstat. The following statistics are the most important statistics that are used by AWR:

OS Statistics - CPU and Memory using v$osstat.

Column	Description
STAT_NAME	Statistic name
VALUE	Statistic value at the moment
OSSTAT_ID	Statistic ID

Wait Classes – CPU, application, commit, concurrency, scheduler, I/O, admin, configuration, commit, cluster, and network are available using v$event_name.

Column	Description
EVENT#	Number of the wait event
EVENT_ID	Wait event identifier
NAME	Wait event name
PARAMETER1	First parameter description for the wait event
PARAMETER2	Second parameter description for the wait event