| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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 |