Re: Shared Pool v$sgastat problem

From: <gbenet_at_intracom.gr>
Date: 21 Jul 2005 23:17:01 -0700
Message-ID: <1122013020.947550.25730@z14g2000cwz.googlegroups.com>

Error messages

ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","select local_tran_id, global...","sga heap","library cache") ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","select job from sys.job$ wh...","sga heap","library cache") ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","select job from sys.job$ wh...","sga heap","library cache") ORA-04031: unable to allocate 4256 bytes of shared memory ("shared pool","unknown object","sga heap","dlm cr bast q") ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknown object","sga heap","multiblock rea")

Contents of v$shared_pool_reserved

FREE_SPACE 23479496.00
AVG_FREE_SIZE 51603.00

FREE_COUNT	2879120879.00
MAX_FREE_SIZE	41.00
USED_SPACE	20245368.00
AVG_USED_SIZE	3364056.00
USED_COUNT	7393.00
MAX_USED_SIZE	52967032967.00
REQUESTS	414.00
REQUEST_MISSES	8152.00
LAST_MISS_SIZE	24303.00
MAX_MISS_SIZE	0.00

REQUEST_FAILURES 0.00
LAST_FAILURE_SIZE 0.00
ABORTED_REQUEST_THRESHOLD 0.00
ABORTED_REQUESTS 0.00
LAST_ABORTED_SIZE 2147483647.00 Instance A
NAME,VALUE
_all_shared_dblinks,

hi_shared_memory_address,0
shared_memory_address,0
_shared_pool_reserved_min_alloc,4400

shared_pool_reserved_size,26843546
shared_pool_size,268435456

Instance B
NAME,VALUE
_all_shared_dblinks,

hi_shared_memory_address,0
shared_memory_address,0
_shared_pool_reserved_min_alloc,4400

shared_pool_reserved_size,26843546
shared_pool_size,268435456 Received on Fri Jul 22 2005 - 01:17:01 CDT