55.Oracle杂记——Oracle常用动态视图v$PGA_TARGET_ADVICE

55.Oracle杂记——Oracle常用动态视图v$PGA_TARGET_ADVICE

视图v$PGA_TARGET_ADVICE 显示如果PGA_AGGREGATE_TARGET参数变化带来的CACHE命中率。

视图描述如下：

idle> desc v$pga_target_advice;

 Name                                                                  Null?    Type

 ------------------------------------------------------------- ------------------------------------

 PGA_TARGET_FOR_ESTIMATE                                                   NUMBER

 PGA_TARGET_FACTOR                                                         NUMBER

 ADVICE_STATUS                                                                     VARCHAR2(3)

 BYTES_PROCESSED                                                                NUMBER

 ESTD_TIME                                                                    NUMBER

 ESTD_EXTRA_BYTES_RW                                                               NUMBER

 ESTD_PGA_CACHE_HIT_PERCENTAGE                                                NUMBER

 ESTD_OVERALLOC_COUNT                                                           NUMBER

 CON_ID                                                                           NUMBER

各个列的含义描述如下：

PGA_TARGET_FOR_ESTIMATE：评估的PGA大小

 PGA_TARGET_FACTOR：评估的PGA大小和当前PGA大小的比值

 ADVICE_STATUS：建议是否打开了

 BYTES_PROCESSED：处理的字节数量

 ESTD_TIME：处理字节的时间

 ESTD_EXTRA_BYTES_RW：是否有多余的字节需要读写

 ESTD_PGA_CACHE_HIT_PERCENTAGE：PGA命中率

 ESTD_OVERALLOC_COUNT：PGA内存过度分配的数量

 CON_ID：容器ID