Making SGA as big as possible always a good idea ?
593075Aug 15 2007 — edited Aug 15 2007Hello,
during trying to learn about oracle i came across the following question:
Lets say i have a rather small database, with all datafiles together not larger than 1GB. And lets assume further that this database should run on a server with 8GB of ram. So, the OS will take some part of the 8GB, but there will be a lot of space left.
Is there any reason for not making the SGA very big, like lets say 1GB ? I think i remember to have read about "lots of logical reads" as a reason for not "oversizing" the SGA at some place on the internet, but as i'm a beginner i may have got that wrong...