8.119 V$PGA_TARGET_ADVICE
V$PGA_TARGET_ADVICE
predicts how the cache hit percentage and over allocation count statistics displayed by the V$PGASTAT
performance view would be impacted if the value of the PGA_AGGREGATE_TARGET
parameter is changed.
The prediction is performed for various values of the PGA_AGGREGATE_TARGET
parameter, selected around its current value. The advice statistic is generated by simulating the past workload run by the instance.
The content of the view is empty if PGA_AGGREGATE_TARGET
is not set. In addition, the content of this view is not updated if the STATISTICS_LEVEL
parameter is set to BASIC
. Base statistics for this view are reset at instance startup and when the value of the PGA_AGGREGATE_TARGET
initialization parameter is dynamically modified.
Column | Datatype | Description |
---|---|---|
|
|
Value of |
|
|
|
|
|
Indicates whether the advice is enabled ( |
|
|
Total bytes processed by all the work areas considered by this advice (in bytes) |
|
|
Time (in seconds) required to process the bytes |
|
|
Estimated number of extra bytes which would be read or written if |
|
|
Estimated value of the cache hit percentage statistic when |
|
|
Estimated number of PGA memory over-allocations if the value of |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
Oracle Database Performance Tuning Guide for information on tuning the
PGA_AGGREGATE_TARGET
initialization parameter using the PGA advice views