Thierry wrote:
>
> Hi
>
> I have two questions :
>
> - Is th SGA blocked in Real Memory i.e. not paged ?
> - why extent is said to be contiguous oracle blocks ? ( on a filesystem we
> can't know where are th filesystem blocks )
>
> Thanks in advance ...
The SGA can be kept in memory - this is H/W dependent - refer to Oracle
docs.
Extents are in contiguous blocks - this is how the kernel manages
space. As far as knowing where contiguous blocks are on a FS,
tablespaces abtract that information away from you. You don't need to
know. If you use partitioning, it is possible to load data into a
specific partition (a specific file on a specific disk).
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Mon Oct 08 2001 - 15:31:00 CDT
