Database Tuning (MOSC)

MOSC Banner

Need explain about V$SQL_WORKAREA_HISTOGRAM

edited Mar 26, 2012 8:28PM in Database Tuning (MOSC) 3 commentsAnswered
   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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center