Enabling Automatic Shared Memory Management - wykład

Enabling Automatic Shared Memory Management
This section describes how to change to automatic shared memory management if
either automatic memory management or manual shared memory management is
currently enabled for your database instance.
To change to automatic shared memory management if automatic memory
management is currently enabled:
If automatic memory management is currently enabled, but you would like to have
more direct control over the sizes of the SGA and instance PGA, you can disable
automatic memory management and enable automatic shared memory management.
Follow these steps:
1. In EM Express, from the Configuration menu, select Initialization Parameters.
The Initialization Parameters page appears, with the Current tab displayed.
2. In the Search field, enter MEMORY_TARGET.
3. Select MEMORY_TARGET, and then click Set.
The Set Initialization Parameter page appears.
4. In the Value field, enter 0, specify a Scope of Memory, and then click OK.
... zobacz całą notatkę