December 2002
Intermediate to advanced
928 pages
85h 29m
English
PRE_PAGE_SGA
Value: TRUE | FALSE
Default: FALSE
If TRUE, Oracle touches all of the SGA pages during instance startup, causing them to be brought into memory. As a result, setting this parameter increases instance startup time and user login time, but it can reduce the number of page faults that occur shortly thereafter. The reduction in page faults allows the instance to reach its maximum performance capability more quickly. This parameter is most useful on systems that have sufficient memory to hold all the SGA pages without degrading performance in other areas. You should ensure that the SGA be sized properly in relation to existing physical memory in order to avoid swapping.