|
|
| Re: How manage over 8GB memory [message #129398 is a reply to message #129392] |
Mon, 25 July 2005 01:43   |
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 |
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
/
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
