ORA-04031 Unable to allocate xx bytes of shared memory

tetrix03_cafia2odb02

alert_tetrix03.log

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /u01/app/oracle/diag/rdbms/tetrix03_cafia2odb02/tetrix03/trace/tetrix03_smon_14876870.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^f185eace","kglHeapInitialize:temp")

 

Restart Databse

 

 

Configuring Memory Manually

https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11202

 

ORA-04031 Unable to allocate xx bytes of shared memory

http://www.solgle.com/news/224.html

 

Oracle11g 后台进程概述

http://blog.itpub.net/7695891/viewspace-66982

 

Oracle 进程 说明

http://blog.csdn.net/tianlesoftware/article/details/6711694

 

Case Study: 

Errors in file /u01/app/oracle/diag/rdbms/tetrix03_cafia2odb02/tetrix03/trace/tetrix03_cjq0_37027944.trc:

ora-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","KGLH0^8cc6e92e","kglHeapInitialize:temp")

===============================

End 4031 Diagnostic Information

===============================

Incident 7646 created, dump file: /u01/app/oracle/diag/rdbms/tetrix03_cafia2odb02/tetrix03/incident/incdir_7646/tetrix03_cjq0_37027944_i7646.trc

ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","KGLH0^8cc6e92e","kglHeapInitialize:temp")

 

*** 2015-05-31 18:01:22.923

ORA-00604: error occurred at recursive SQL level 1

ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","KGLH0^8cc6e92e","kglHeapInitialize:temp")

 

*** 2015-05-31 18:01:33.136

DBMS_STATS: GATHER_STATS_JOB: Stopped by Scheduler.

DBMS_STATS: Consider increasing the maintenance window duration if this happens frequently.

DBMS_STATS: The following objects/segments were not analyzed due to timeout:

Closing scheduler window

 

*** 2015-06-01 02:00:00.078

Closing Resource Manager plan via scheduler window

Clearing Resource Manager plan via parameter

 

https://community.oracle.com/thread/2282202?start=15&tstart=0

ORA-04031: unable to allocate 32 bytes of shared memory.

 

https://community.oracle.com/thread/386169

How to find out total memory used by each database ?

 

http://www.dba-oracle.com/art_dbazine_ram.htm

Optimizing Oracle RAM for SGA & PGA

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26477398/viewspace-2122497/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26477398/viewspace-2122497/