Database Tuning (MOSC)

MOSC Banner

shared pool running out of memory

edited Sep 11, 2014 5:01AM in Database Tuning (MOSC) 9 commentsAnswered

Hello expert,

                     Recently in one of the database we were hitinh ora-4031 as shared pool was running out of memory.We flushed shared pool and after that issue got resolved.We understand sga needs to be increased but can't understand how much we have to and what will be the benefit?Please suggest us.

SQL> SELECT parameter, oper_type, oper_mode, initial_size, target_size, status, start_time, end_time FROM v$sga_resize_ops
  2  where trunc(start_time)=trunc(sysdate);

PARAMETER                      OPER_TYPE     OPER_MODE INITIAL_SIZE TARGET_SIZE STATUS    START_TIME        END_TIME
------------------------------ ------------- --------- ------------ ----------- --------- ----------------- -----------------

Tagged:

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