Home » RDBMS Server » Server Administration » To increase the Shared_Pool Size (Solaries,9.2.0)
icon5.gif  To increase the Shared_Pool Size [message #400508] Tue, 28 April 2009 09:10 Go to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
Hi All,

I want to increase the Shered pool Size...

On What basis we will increase the shared pool size...

Application team getting SHARED MEMORY Releam Error.

My Current Shared Pool Size is 100m,

Total SGA 360m,

Server 32Gb Real memory and 2.5 GB freemomry is avilable..

How Much Can I Increase the Shared Pool..????
Re: To increase the Shared_Pool Size [message #400509 is a reply to message #400508] Tue, 28 April 2009 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to increase the Shered pool Size...

Why?
If you can answer this question then you will answer your next one.

Quote:
Application team getting SHARED MEMORY Releam Error.

Not helpful, there are hundreds of them.

Quote:
How Much Can I Increase the Shared Pool..????

Changing the appropriate parameter (depending on the error you didn't post)... or your application.

Regards
Michel

Re: To increase the Shared_Pool Size [message #400629 is a reply to message #400509] Wed, 29 April 2009 02:47 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
Thanks For Your Help Michel

I have Increased the shared pool size up to 100 to 150 mb..

Is there any ratio...for all components in SGA...!!!!

Re: To increase the Shared_Pool Size [message #400639 is a reply to message #400629] Wed, 29 April 2009 03:21 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Post acutall error message (like ORA-)

Post database version (4 digit)

Babu
Re: To increase the Shared_Pool Size [message #400763 is a reply to message #400639] Wed, 29 April 2009 07:44 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
Error is ORA-4031

And the version is 9.2.0.8.0.

Thanks
Babu.
Re: To increase the Shared_Pool Size [message #400771 is a reply to message #400763] Wed, 29 April 2009 08:07 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-4031 is which space?
ORA-4031 is generic to all sga space error.
Full message needed (as already said).

Regards
Michel
Previous Topic: Cant run run installer during patching 10.2.0.4
Next Topic: Variable size memory
Goto Forum:
  


Current Time: Mon Dec 05 18:54:58 CST 2016

Total time taken to generate the page: 0.08540 seconds