Home » Infrastructure » Unix » What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux (Oracle 10g,Solaris 9)
What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395704] Thu, 02 April 2009 05:44 Go to next message
csfreebird
Messages: 5
Registered: April 2009
Location: shanghai,china
Junior Member
thanks
Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395706 is a reply to message #395704] Thu, 02 April 2009 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
About the one defined by ulimit at OS level.

Regards
Michel
Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395715 is a reply to message #395706] Thu, 02 April 2009 06:51 Go to previous messageGo to next message
csfreebird
Messages: 5
Registered: April 2009
Location: shanghai,china
Junior Member
We found when the memory of PGA is more than 2.7GB,our pl/sql application catches the exception:ORA-06500.
Some one said it was limited by OS,we have solaris 9 and UBuntu 8.10.
Can we adjust it????

Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395717 is a reply to message #395715] Thu, 02 April 2009 06:56 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux

It's depents you.

1/ What's your SGA size

2/ What's your Ram Size

Babu Baskar

Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395718 is a reply to message #395704] Thu, 02 April 2009 07:02 Go to previous messageGo to next message
csfreebird
Messages: 5
Registered: April 2009
Location: shanghai,china
Junior Member
Our physical memory is 4GB,
Our pl/sql application doesn't need large SGA,we have tested it.
How can I adjust my PGA?

[Updated on: Thu, 02 April 2009 07:12]

Report message to a moderator

Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395733 is a reply to message #395715] Thu, 02 April 2009 08:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-06500: PL/SQL: storage error
 *Cause: PL/SQL was unable to allocate additional storage.  This message
         normally appears with an ORA-4030 or ORA-4031 error which gives
         additional information.  Sometimes this error can be caused by
         runaway programs.
 *Action: 1) Ensure there are no issues or bugs in your PL/SQL program which
             are causing excessive amounts of memory to be used.
          2) Programmatically cause unused objects to be freed (e.g. by
             setting them to NULL).
          3) Increase the amount of shared or process memory (as appropriate)
             available to you.

Regards
Michel
Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395845 is a reply to message #395733] Thu, 02 April 2009 18:42 Go to previous messageGo to next message
csfreebird
Messages: 5
Registered: April 2009
Location: shanghai,china
Junior Member
I just want to find a way to adjust the maximum memory of PGA.
My OS is 32bit system,Solaris 9 and UBuntu 8.10.
The prblem about pl/sql is not my question.Thanks.
Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395849 is a reply to message #395704] Thu, 02 April 2009 19:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

The Posting Guidelines state you should use GOOGLE before posting
Results 1 - 10 of about 5,730 for adjust the maximum memory of PGA.

Are you claiming that none of the 5000+ responses give you any clue?

What Oracle version to 4 decimal places?

Why do you think the PGA needs to be set to maximum value?

[Updated on: Thu, 02 April 2009 19:20]

Report message to a moderator

Re: What's the maximal memory of PGA in Oracle 10g R2 on Solaris 9 or Linux [message #395868 is a reply to message #395845] Thu, 02 April 2009 23:35 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You do not and can not set maximum PGA memory.

Regards
Michel
Previous Topic: How to get Duplicate rows in a file
Next Topic: Unable to interpret environmental variable
Goto Forum:
  


Current Time: Tue Dec 17 20:10:42 CST 2024