Database Memory & 4030/4031 (MOSC)

MOSC Banner

ORA-04031: unable to allocate 4192 bytes of shared memory ("shared pool","select f.file#, f.block#,

edited Dec 6, 2009 9:10PM in Database Memory & 4030/4031 (MOSC) 4 commentsAnswered
Hi Team,

   I'm gettign this error very frequently..can any one tell me the permanent fix..

DB Configuration.

Version : 10.2.0.4

SQL> show sga

Total System Global Area 2097152000 bytes
Fixed Size                  2139928 bytes
Variable Size             345987304 bytes
Database Buffers         1610612736 bytes
Redo Buffers              138412032 bytes

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
lock_sga                             boolean                          FALSE
pre_page_sga                         boolean                          FALSE
sga_max_size                         big integer                      2000M
sga_target                           big integer                      2000M

$ uname -X
System = SunOS
Node = ntsp08
Release = 5.10
KernelID = Generic_127111-09
Machine = sun4v
BusType = <unknown>
Serial = <unknown>
Users = <unknown>
OEM# = 0
Origin# = 1
NumCPU = 128

$ uname -a
SunOS ntsp08 5.10 Generic_127111-09 sun4v sparc SUNW,T5240

Options Already Tried are

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