Need explain about V$SQL_WORKAREA_HISTOGRAM
Hi all,
My oracle version 9.2.0.4 on Unix
Belong document about PGA in oracle 9i, using pga_aggregate_target and workarea_size_policy made Oracle auto management memory PGA.
Also, it said that monitoring the performance of the Automatic PGA memory management by view V$SQL_WORKAREA_HISTOGRAM. If use bellow script:
SELECT LOW_OPTIMAL_SIZE/1024 low_kb, (HIGH_OPTIMAL_SIZE+1)/1024 high_kb, OPTIMAL_EXECUTIONS, ONEPASS_EXECUTIONS, MULTIPASSES_EXECUTIONS
FROM V$SQL_WORKAREA_HISTOGRAM
WHERE TOTAL_EXECUTIONS != 0;
And assume that ONEPASS_EXECUTIONS and MULTIPASSES_EXECUTIONS appear most of cases, it mean size of PGA is small and I need increase size ? Am I right ?
0