V$SGA_TARGET_ADVICE
displays information about the SGA_TARGET
initialization parameter.
Column | Datatype | Description |
---|---|---|
|
|
Size of the SGA |
|
|
Ratio between the SGA_SIZE and the current size of the SGA |
|
|
Estimated DB_TIME for this SGA_SIZE |
|
|
Ratio between ESTD_DB_TIME and DB_TIME for the current size of the SGA |
|
|
Estimated number of physical reads |
|
|
Estimated size of the buffer cache |
|
|
Estimated size of the shared pool |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: