OraFAQ Forum: Server Administration » Just a quicky question (SHARED_POOL

Home » RDBMS Server » Server Administration » Just a quicky question (SHARED_POOL_SIZE)

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

Just a quicky question (SHARED_POOL_SIZE) [message #62320]

Wed, 14 July 2004 04:34

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

�

We've got 4 instances set up exactly the same with a SHARED_POOL_SIZE set to 52428800. Each instance is around 40 Gig in size. Is this value about right? The databases run on a Sun Solaris Unix box with 4096 Meg of memory (Oracle 8i).

Report message to a moderator

Re: Just a quicky question (SHARED_POOL_SIZE) [message #62325 is a reply to message #62320]

Wed, 14 July 2004 10:50

Sanjay
Messages: 236
Registered: July 2000

Senior Member

There are many things that affect the size you need for SHARED_POOL_SIZE.

Just looking at it, sounds OK (50M for Shared_Pool) for a medium size DB.

Again, there are many things that affect the size you need for SHARED_POOL_SIZE.

Are you having any performance issues ?

Report message to a moderator

Re: Just a quicky question (SHARED_POOL_SIZE) [message #62331 is a reply to message #62325]

Wed, 14 July 2004 23:50

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Hello Sanjay, Thanks for your reply. Our system is working fine i was just curious about our settings we've chosen. Our system is a new one which goes live in about a weeks time so i was just double checking things.
Thanks again for your info.

Report message to a moderator

Re: Just a quicky question (SHARED_POOL_SIZE) [message #62354 is a reply to message #62331]

Fri, 16 July 2004 11:10

Sanjay
Messages: 236
Registered: July 2000

Senior Member

You can do 1 more thing.

Log into all the database (as SYS) and do a 'show sga'. Add all these up and this is the total mem used in your server.

I beleive you have 4 GB physical mem. How much swap space do you have? Make it at least 2 GB, if possible 4 GB.

Good luck.

SQL> show sga

Total System Global Area  472417496 bytes
Fixed Size                   742616 bytes
Variable Size             201326592 bytes
Database Buffers          268435456 bytes
Redo Buffers                1912832 bytes

--
Sanjay

Report message to a moderator

Re: Just a quicky question (SHARED_POOL_SIZE) [message #62431 is a reply to message #62354]

Wed, 21 July 2004 13:43

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Hello Sanjay, just noticed your last reply while i was browsing through other people's queries. The actual swap space i gave when i built the Unix machine was 3.25 Gig. Thanks again.

Report message to a moderator

Previous Topic:	changing database from non-archieve to archieve mode
Next Topic:	table changes and user activity

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 04:16:47 CST 2025