| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01  | 
  | 
  | 
View PDF | 
DBA_HIST_SGA displays historical summary information about the system global area (SGA). This view contains snapshots of V$SGA.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
SNAP_ID | 
NUMBER | 
NOT NULL | 
Unique snapshot ID | 
DBID | 
NUMBER | 
NOT NULL | 
Database ID for the snapshot | 
INSTANCE_NUMBER | 
NUMBER | 
NOT NULL | 
Instance number for the snapshot | 
NAME | 
VARCHAR2(64) | 
NOT NULL | 
SGA component group | 
VALUE | 
NUMBER | 
NOT NULL | 
Memory size (in bytes) |