![]() When system memory is greater than 4 gigabytes, automatic memory management is disabled, and automatic shared memory management is enabled. If you create your database with Database Configuration Assistant (DBCA) and choose the basic installation option, automatic memory management is enabled when system memory is less than or equal to 4 gigabytes. These memory management methods are described later in this chapter. Manual PGA memory management - for the instance PGA Manual shared memory management - for the SGAĪutomatic PGA memory management - for the instance PGA These methods are:Īutomatic shared memory management - for the SGA ![]() The methods therefore vary in the amount of effort and knowledge required by the DBA. Some of these methods retain some degree of automation. There are a few different methods available for manual memory management. If you prefer to exercise more direct control over the sizes of individual memory components, you can disable automatic memory management and configure the database for manual memory management.
0 Comments
Leave a Reply. |