Home » RDBMS Server » Server Administration » ? % of memory to SGA?
? % of memory to SGA? [message #54515] Wed, 20 November 2002 07:52 Go to next message
raman
Messages: 66
Registered: February 2000
Member
Hi

I just want to know what % of memory should I allocate for SGA?

thnx,
Raj

Report message to a moderator

Re: ? % of memory to SGA? [message #54517 is a reply to message #54515] Wed, 20 November 2002 08:21 Go to previous messageGo to next message
Kossaku Nakombi
Messages: 12
Registered: November 2002
Junior Member
The total amount of physical memory available should be distributed to:
1. Operating System
2. SGA
3. Oracle Background Processos
4. Other

So, the amount available to SGA depends.

Report message to a moderator

Re: ? % of memory to SGA? [message #54522 is a reply to message #54517] Wed, 20 November 2002 10:03 Go to previous messageGo to next message
tt
Messages: 16
Registered: September 2000
Junior Member
If Oracle DB is standalone on the server, if there aren't other applications running, I usually allocate %25 of the total server memory for Oracle.

Report message to a moderator

Re: ? % of memory to SGA? [message #54561 is a reply to message #54515] Thu, 21 November 2002 12:08 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Use the Oracle default settings when create new database, then run This script to fine tune the SGA. It will give you an recommendations which area to change and with how much.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: CONNECT_TIMEOUT
Next Topic: DB Links
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:45:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.