See the RAM is 1GB and Database is 20 GB
Then, what should be the SGA size .
Kindly make it asap..
Saravanan Oracle DBA(8i OCP)
SGA can be upto 500MB. What is the present SGA setting?
Moreover, check v$sgastat for 'free memory' after 1 day of peak activity.
Oracle recommeds that you should leave 20% of RAM for unix processes. If this is the case you could use up to 80% or the RAM (if there is only one instance running).
OCP 8i, 9i DBA
Originally posted by grjohnson
Oracle recommeds that you should leave 20% of RAM for unix processes.
Can you please post the link/url of this note/article to facilitate a detailed study of this issue.
Thanks & Regards.
[Edited by ggnanaraj on 09-24-2002 at 02:29 AM]
SGA can actually be as big as you want as long as you avoid paging and swapping.
saran - depends on database requirements as to how you size SGA. To start with, you need to run some scripts on dictionary cache, library cache, buffer pool, redo log buffer and check hit ratio's to decide how to size these areas.
I think you will find these scripts at this site. They are also posted all over the web.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Click Here to Expand Forum to Full Width