| memory issue [message #511119] |
Thu, 09 June 2011 11:46  |
patdev
Messages: 73
Registered: August 2008
|
Member |
|
|
Oracle 10.2.0.4 (user or developer getting error for not able to allocate ora 04031
I am trying to do alter system shared_pool_size = 250M but it says
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
I checked the show parameter sga_max_size = 376 M
the set upin the init.ora for pools:
###########################################
# Pools
###########################################
java_pool_size=157286400
large_pool_size=33554432
shared_pool_size=157286400
From show parameter sga;
NAME TYPE VALUE
----------- lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 376M
sga_target big integer 0
SQL> select * from V_$SGA_TARGET_ADVICE;
no rows selected
OS Linux.
this was the message in alert.log;
ORA-04031: unable to allocate 88 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","sql area","opn: qkexrInitOpn")
what is the problem to increase the shared pool>> Please help quick
|
|
|
|
| Re: memory issue [message #511124 is a reply to message #511119] |
Thu, 09 June 2011 12:16  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
patdev wrote on Thu, 09 June 2011 12:46
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
You do not have enough memory, increase SGA_MAX_SIZE...
[Updated on: Thu, 09 June 2011 12:18] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: memory issue [message #511423 is a reply to message #511119] |
Mon, 13 June 2011 00:35 |
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
|
Senior Member |
|
|
Do you really need a 150MB Java Pool ? You could reduce that first !
"ASSM" is Automatic Segment Space Management --- it has nothing to do with memory management. I guess that you were referring to "ASMM" which is "Automatic Shared Memory Management" (which refers to management of the components within the SGA).
Hemant K Chitale
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
