Re: PRE_PAGE_SGA

Michael,

When you start an Oracle instance it (by default) allocates the SGA in virtual memory. Subsequent use of the database will page REAL data into physical memory. When you start with PRE_PAGE_SGA it 'touches' all SGA pages in physical memory. This takes time and does not make any data available. If you want to have data stored in memory after the instance is started you should run some sql scripts to bring data into the SGA.

Regards,

Mike

Michael Bethke wrote:
> is there anyone who can tell me something about the
> INIT.ORA-parameter PRE_PAGE_SGA ?
> I didn't see any changes in v$rowcache and v$sgastat
> after restarting the instance.
>
> So what will be prepaged ???
Received on Wed Dec 11 1996 - 00:00:00 CST