ORA-04031: unable to allocate 4192 bytes of shared memory ("shared pool","select f.file#, f.block#,
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