OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » memory issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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 #511125 is a reply to message #511124]

Thu, 09 June 2011 12:20

patdev
Messages: 73
Registered: August 2008

Member

how? also, I do not have ASSM enable either is it fine?

Report message to a moderator

Re: memory issue [message #511126 is a reply to message #511119]

Thu, 09 June 2011 12:21

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I am trying to do alter system shared_pool_size = 250M but it says

You must use SQL*Plus and copy and paste what you do and get as it without trying to explain us.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: memory issue [message #511130 is a reply to message #511125]

Thu, 09 June 2011 12:24

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

patdev wrote on Thu, 09 June 2011 19:20

how? also, I do not have ASSM enable either is it fine?

Most likely no but this has nothing to do with your current problem.

Regards
Michel

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

Report message to a moderator

Previous Topic:	Can't login using sqlplus
Next Topic:	Listener Issue (split from completely unrelated topic)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 18:38:14 CDT 2024