Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question
In article <bcafa78d.0208012047.26645b22_at_posting.google.com>,
compujalal_at_yahoo.com says...
> hi
>
> Where is the SGA stored ,in Virtual Memory or RAM ?
>
> When is the RAM used in ORACLE (I mean during which process ,does
> Oracle uses RAM and to store what)?
>
> How is that Large block size decreases no. of i/o's ,While Small block
> size increases the no. of i/o's?
>
The SGA and all Oracle processes require "memory". It's up to the OS to determine if enough RAM is available, or if virtual memory (on disk) is required. The goal is to tune your system so that everything fits in available RAM.
A larger block means you can retrieve more data per I/O. If you're retrieving lots of data spread out over small blocks (like 4K), that translates to a lot of I/O.