V$SGA_TARGET_ADVICE provides information about the SGA_TARGET initialization parameter.
| Column | Datatype | Description |
|---|---|---|
SGA_SIZE |
NUMBER |
Size of the SGA |
SGA_SIZE_FACTOR |
NUMBER |
Ratio between the SGA_SIZE and the current size of the SGA |
ESTD_DB_TIME |
NUMBER |
Estimated DB_TIME for this SGA_SIZE |
ESTD_DB_TIME_FACTOR |
NUMBER |
Ratio between ESTD_DB_TIME and DB_TIME for the current size of the SGA |
ESTD_PHYSICAL_READS |
NUMBER |
Estimated number of physical reads |