OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » sga size urgent

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

sga size urgent [message #168747]

Sat, 22 April 2006 00:20

reyazan
Messages: 53
Registered: February 2005

Member

i have windows 2000 server with 2 gb ram and oracle 8i 1.7
enterprise (database general) installed.

what is size of sga i should create

Report message to a moderator

Re: sga size urgent [message #168754 is a reply to message #168747]

Sat, 22 April 2006 02:07

kmsalih
Messages: 197
Registered: March 2006

Senior Member

Hi,

General

Total SGA : 50% of RAM.
Shared Pool : 45% of SGA
Database Buffer Cache : 45% of SGA
Redo Log Buffer : 10% of SGA

It is not recommended that the redo log buffer to be more than 1MB.

So Divide the balance of Redo Log Buffer among the other memory structures.

Rgds
SALIH KM Cool

Report message to a moderator

Previous Topic:	sql*plus problem in 10g
Next Topic:	SID IN 10G

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:31:55 CDT 2024