-
memory issue 10.2.0.4
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
-
You can see other pools consuming memory in the SGA, so the obvious answer is to reduce how much is allocated for those other items, or make the SGA larger.
Last edited by stecal; 06-09-2011 at 04:02 PM.
-
Most people don't need 150MB of java_pool_size.
You can probably shrink that to 48MB.
You should then be able to grow the shared_pool_size.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|