C.2.12 DBA_HIST_CELL_GLOBAL_SUMMARY

The DBA_HIST_CELL_GLOBAL_SUMMARY view displays historic information about the performance of cells. For each AWR snapshot, a summary of the per-minute metrics is visible in this view. This is a summary of V$CELL_GLOBAL_HISTORY.

Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot ID

DBID

NUMBER

NOT NULL

Database identifier for the snapshot.

CELL_HASH

NUMBER

NOT NULL

Hash number that uniquely identifies the cell.

INCARNATION_NUM

NUMBER

NOT NULL

Incarnation number of the cell.

NUM_SAMPLES

NUMBER

Number of 1 minute samples the summary is based on.

CPU_USAGE_SUM

NUMBER

Sum of the per-minute CPU usage percentage metrics.

SYS_USAGE_SUM

NUMBER

Sum of the per-minute system CPU usage percentage metrics.

USER_USAGE_SUM

NUMBER

Sum of the per-minute user CPU usage percentage metrics.

NETWORK_BYTES_RECD_SUM

NUMBER

Sum of the per-minute network received metrics, in bytes per second.

NETWORK_BYTES_SENT_SUM

NUMBER

Sum of the per-minute network sent metrics, in bytes per second.

*_SUMX2

NUMBER

All previous columns from CPU_USAGE to NETWORK_BYTES_SENT are repeated with the SUMX2 suffix.

This is the sum of squares of the per-minute metrics.

*_AVG

NUMBER

All previous columns from CPU_USAGE to NETWORK_BYTES_SENT are repeated with the SUMX2 suffix.

This is the average of the per-minute metrics.

CON_DBID

NUMBER

The database identifier.

CON_ID

NUMBER

The identifier of the container identified by CON_DBID. Possible values are as follows:

  • 0: This value is used for non-container database (CDB).

  • 1: This value is used for the root container of the CDB.

Parent topic: Automatic Workload Repository Views