Reconfiguring Oracle9i Dynamically

Dynamic Reconfiguration (DR) support in Solaris and on Sun hardware is described under “Dynamic Reconfiguration” on page 26, along with a discussion on its implications for databases.

Oracle9i Dynamic System Global Area

Oracle’s Dynamic System Global Area (SGA) capability, released with Oracle9i, for the first time offers the capability of altering the size of the SGA while the database is live. In particular, Oracle9i supports changes to the sizes of the buffer cache and shared pool, the two major components of the SGA. When intimate shared memory (ISM) is used for the SGA, the amount of memory allocated to the buffer cache and the shared pool can be traded off against each other, although the total amount ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.