shared pool error
646155Nov 1 2010 — edited Nov 2 2010hi guys i have performed a switchover to the logical standby database.. and after that the primary databasenow the logical standby is not getting updated and log files show the following error....
DDE: Problem Key 'ORA 4031' was flood controlled (0x2) (incident: 13527)
ORA-04031: unable to allocate 396 bytes of shared memory ("shared pool","unknown object","Logminer LCR c","krvxbmtx")
krvxlclc: op 0
ORA-04031: unable to allocate 396 bytes of shared memory ("shared pool","unknown object","Logminer LCR c","krvxbmtx")
*** 2010-11-02 02:58:50.815
AUTO MEM: PGA get fail 65 for 29, 56, 1, 4194304, 150994944, 121634816, , 29, 272629760, 4
DDE: Problem Key 'ORA 4031' was flood controlled (0x2) (incident: 13528)
ORA-04031: unable to allocate 808 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","KGLHD")
ORA-04031: unable to allocate 396 bytes of shared memory ("shared pool","unknown object","Logminer LCR c","krvxbmtx")
KGX cleanup...
KGX Atomic Operation Log 0x2ad58774
Mutex 0x2e3bcf9c(149, 0) idn 230f oper EXCL
Library Cache uid 149 efd 12 whr 62 slp 0
oper=4 pt1=0 pt2=0 pt3=0
pt4=0 pt5=0 ub4=0
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 808 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","KGLHD")
ORA-04031: unable to allocate 396 bytes of shared memory ("shared pool","unknown object","Logminer LCR c","krvxbmtx")
KSV 604 error in slave process
*** 2010-11-02 02:58:50.901
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 808 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","KGLHD")
ORA-04031: unable to allocate 396 bytes of shared memory ("shared pool","unknown object","Logminer LCR c","krvxbmtx")
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 808 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","KGLHD")
ORA-04031: unable to allocate 396 bytes of shared memory ("shared pool","unknown object","Logminer LCR c","krvxbmtx")
help please....... can i increase the MEMORY_TARGET from 260M to higher value... working on vmware on laptop...