| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
V$SGA_TARGET_ADVICE displays 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 |
