Home Oracle Commands v$ Performance views
Oracle Data Dictionary

V$PGA_TARGET_ADVICE_HISTOGRAM

Data Dictionary View

Columns
   ___________________________
 
   PGA_TARGET_FOR_ESTIMATE
   PGA_TARGET_FACTOR
   ADVICE_STATUS
   LOW_OPTIMAL_SIZE
   HIGH_OPTIMAL_SIZE
   ESTD_OPTIMAL_EXECUTIONS
   ESTD_ONEPASS_EXECUTIONS
   ESTD_MULTIPASSES_EXECUTIONS
   ESTD_TOTAL_EXECUTIONS
   IGNORED_WORKAREAS_COUNT

Related:



Simon Sheppard
SS64.com