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 |