| ORA-04031: unable to allocate 256 bytes of shared memory [message #474542] |
Tue, 07 September 2010 00:54  |
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
|
Member |
|
|
Hallo
When user insert rows in table oracle interrupts and raise error-
ORA-04031: unable to allocate 256 bytes of shared memory
Please suggest what to do? And how to do?
I tried to increase the size of shared_pool also but cant.
large_pool_size = 0
shared_pool_size=134217728(128M)
sga_max_size=218103808(208M)
And when I fire 'select* from v$sga;'
Fixed Size 2142976
Variable Size 159386880
Database Buffers 50331648
Redo Buffers 5296128
Regards//neha
|
|
|
|
|
|
| Re: ORA-04031: unable to allocate 256 bytes of shared memory [message #474546 is a reply to message #474545] |
Tue, 07 September 2010 01:48  |
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
|
Member |
|
|
please see this below...
I did not understand this file what it says.
Errors in file /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/testdb/TESTDB/trace/TESTDB_cjq0_4123.trc (incident=2664):
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","sql area","tmp")
Errors in file /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/testdb/TESTDB/trace/TESTDB_cjq0_4123.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, ...","sql area","tmp")
Errors in file /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/testdb/TESTDB/trace/TESTDB_ora_9182.trc (incident=3369):
ORA-04031: unable to allocate 3944 bytes of shared memory ("shared pool","select type#,blocks,extents,...","Typecheck","kggfaDoKghAlloc")
Errors in file /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/testdb/TESTDB/trace/TESTDB_ora_9182.trc (incident=3370):
ORA-04031: unable to allocate 3944 bytes of shared memory ("shared pool","select type#,blocks,extents,...","Typecheck","kggfaDoKghAlloc")
Tue Sep 07 12:02:16 2010
Errors in file /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/testdb/TESTDB/trace/TESTDB_mmon_4065.trc (incident=3302):
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","sql area","tmp")
Errors in file /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/testdb/TESTDB/trace/TESTDB_ora_9182.trc (incident=3371):
ORA-04031: unable to allocate 1064 bytes of shared memory ("shared pool","select type#,blocks,extents,...","Typecheck","kggfaDoKghAlloc:1")
Errors in file /u01/app/oracle/product/11.1.0/db_1/log/diag/rdbms/testdb/TESTDB/trace/TESTDB_mmon_4065.trc (incident=3303):
ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","Typecheck","qcsqlpath: qcsAddSqlPath")
Tue Sep 07 12:02:20 2010
Sweep Incident[3371]: completed
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
