Boolean 

Static 

FALSE 

FALSE |TRUE 

PRE_PAGE_SGA determines whether all SGA pages are brought into memory at instance startup. Operating system page table entries are then prebuilt for each page of the SGA. The resulting decrease in disk I/O may be offset by performance degradation in other areas. Therefore, this parameter is most useful on systems that have sufficient memory to hold all the SGA pages without degrading performance in other areas. 

See Also: Oracle8i Designing and Tuning for Performance for a discussion of the advantages and disadvantages of setting this parameter to TRUE.