Home » RDBMS Server » Performance Tuning » How manage over 8GB memory
How manage over 8GB memory [message #129392] Mon, 25 July 2005 00:02 Go to next message
enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia
Member

Dear all,

My server has over 8GB RAM.
How manage big memory on the Oracle 9i under Windows 2003.





Re: How manage over 8GB memory [message #129398 is a reply to message #129392] Mon, 25 July 2005 01:43 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

Do check out the requirement of yours for minimum/maximum SGA size & allocate memory accordingly. General rule is if machine is used for running oracle server only, you can allocate 60-70% of your memory to SGA.
Or otherwise you can start with SGA of say 2gb(25% of RAM) and then based on performance observations, increase/reduce size of SGA accordingly.

Regds
Girish
Re: How manage over 8GB memory [message #129508 is a reply to message #129392] Mon, 25 July 2005 08:55 Go to previous messageGo to next message
SoporteDBA
Messages: 7
Registered: July 2005
Location: Écija, Sevilla
Junior Member
Hello,

Sometime ago, I found this query (I think by metalink), that makes you an stimation ...

SELECT (A+B+C+D)/1024 + ((((A+B+C+D)*30)/100)/1024) "KBYTES SHARED POOL"FROM
(select sum(sharable_mem) A from v$db_object_cache) A,
( select sum(sharable_mem) B from v$sqlarea) B,
( select sum(sharable_mem) C from v$sqlarea where executions > 5) C,
( select sum(250 * users_opening) D from v$sqlarea) D
/
Re: How manage over 8GB memory [message #131859 is a reply to message #129392] Tue, 09 August 2005 15:53 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Make sure you do not allocate so much that Oracle does page faults.
Previous Topic: who reads the redo logs
Next Topic: best strategy to gather statistics in a very dynamic
Goto Forum:
  


Current Time: Fri May 27 17:55:16 CDT 2022