Question: Can you please explain the pre_page_sga parameter? How does pre_page_sga work with RAC?
Answer: At instance startup time, Oracle only allocates SGA RAM when needed, but you can avoid this by setting pre_page_sga=true. With pre_page_sga=true, Oracle will pre-allocate all of the the SGA RAM at startup time. This will increase the time required to start the database instance, but it will ensure that the RAM is immediately available for the SGA at run-time.
No comments:
Post a Comment