Spotlight on Oracle 10.10

Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

New Features Resolved Issues and Enhancements Deprecated Features Known Issues System Requirements Product Licensing Getting Started Globalization About us Copyright

Select A Memory Management Mode And Allocate Global Memory

There are five steps to use the Memory Management Page. This page documents Step 1.

You can skip this step if you are satisfied with the current memory management mode and global memory allocations, however you should ensure you are satisfied before you fine tune memory components. You should review all your changes against the charts. Remember, you can use this page to investigate the impact of making changes without applying those changes. If appropriate, there is a procedure to apply changes as documented in the last step.

To use the Memory Management Page

Select A Memory Management Mode And Allocate Global Memory
Review Your Changes Against The Charts
Fine Tune Memory Components
Review Your Changes Against The Charts
Apply Changes

Select A Memory Management Mode

When you open the Memory Management page the current memory management mode is selected.

Select a different mode to view the hypothetical status of Oracle memory components under that mode.

Mode	Description
Manual	Automatic memory management is OFF.
Auto SGA Only (ASMM)	Automatic shared memory management is ON for the SGA (System Global Area).
Auto Memory (AMM)	Automatic memory management is ON for the SGA and PGA (Program Global Area). Note: Available for Oracle 11g and later.

Mode

Description

Manual

Automatic memory management is OFF.

Auto SGA Only (ASMM)

Automatic shared memory management is ON for the SGA (System Global Area).

Auto Memory (AMM)

Automatic memory management is ON for the SGA and PGA (Program Global Area).

Note: Available for Oracle 11g and later.

Allocate Global Memory

When you open the Memory Management page the current memory sizes for the system and database are displayed.

Click Edit to view the hypothetical effects of memory reallocation.

Spotlight will comment on the changes. Spotlight's comments may suggest you take further action. The comments may state Spotlight's calculation on memory usage in the selected mode.

Review the effect of the changes: Review Your Changes Against The Charts.

Memory	Description	Applicable Modes
Total Physical Memory	The total amount of physical memory on the host machine. Note: Value N/A if Spotlight is not monitoring the host machine.	All
Free Physical Memory	The amount of available physical memory on the host machine. Note: Value N/A if Spotlight is not monitoring the host machine.	All
Total Oracle Memory	The total amount of physical memory allocated to Oracle processes. Note: Value N/A if Spotlight is not monitoring the host machine.	All
Maximum SGA Memory	The maximum amount of memory that can be allocated to the System Global Area. Note: Any changes you make to this value are applied only when the database is restarted.	Manual and ASMM
Dynamic SGA Memory	The amount of SGA memory that can be allocated dynamically by the database at runtime.	ASMM
Amount of Dynamic Memory	The amount of total Oracle memory that can be allocated dynamically by the database at runtime.	AMM

Note: When a memory area is in AUTO memory management mode, Oracle resizes the area automatically according to the current load.

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Spotlight on Oracle 10.10 - Release Notes

Select A Memory Management Mode And Allocate Global Memory