OraFAQ Forum: Server Administration » To increase the Shared_Pool Size

Home » RDBMS Server » Server Administration » To increase the Shared_Pool Size (Solaries,9.2.0)

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

To increase the Shared_Pool Size [message #400508]

Tue, 28 April 2009 09:10

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..????

Report message to a moderator

Re: To increase the Shared_Pool Size [message #400509 is a reply to message #400508]

Tue, 28 April 2009 09:13

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: To increase the Shared_Pool Size [message #400629 is a reply to message #400509]

Wed, 29 April 2009 02:47

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...!!!!

Report message to a moderator

Re: To increase the Shared_Pool Size [message #400639 is a reply to message #400629]

Wed, 29 April 2009 03:21

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

babu.knb@gmail.com

Post acutall error message (like ORA-)

Post database version (4 digit)

Babu

Report message to a moderator

Re: To increase the Shared_Pool Size [message #400763 is a reply to message #400639]

Wed, 29 April 2009 07:44

madhavamanohar
Messages: 58
Registered: February 2009

Member

Error is ORA-4031

And the version is 9.2.0.8.0.

Thanks
Babu.

Report message to a moderator

Re: To increase the Shared_Pool Size [message #400771 is a reply to message #400763]

Wed, 29 April 2009 08:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Cant run run installer during patching 10.2.0.4
Next Topic:	Variable size memory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 18:00:43 CST 2024