Quote:
Originally posted by ronnie
Well, if you have 512 MB RAM and you make SGA 2 GB, there will be very serious consequences on the database.
RAM is the 'Real' memory available on the system, which is 512 MB. However, since you have allocated much more than this for SGA, your OS will page the SGA out of real memory into virtual memory, which is nothing but space on hard disk. So, everytime you issue command for Oracle, the disk and disk controllers come into picture. Working onto real memory is much faster (that is why we have SGA in the first place!)
Pardon me Sir. When I meant increase SGA to 2GB, I ofcourse meant that physical RAM will be atleast 4 GB. Sorry for the mis-coception.