New Feature of Oracle11g: Automatic Memory Management

Welcome to the Oracle community forum and interact with 2 million technical staff. One of the new features that Oracle 11g is known to be introducing is-Automatic Memory Management Oracle introduced automatic PGA adjustment in Oracle9i; auto SGA adjustment is introduced in Oracle10g, while in 11g, Oracle can automatically adjust all memory usage by setting a parameter,

Welcome to the Oracle community forum and interact with 2 million technical staff> one of the new features that Oracle 11g is known to be introducing is-Automatic Memory Management Oracle introduced automatic PGA adjustment in Oracle9i; auto SGA adjustment is introduced in Oracle10g, while in 11g, Oracle can automatically adjust all memory usage by setting a parameter,

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

One of the new features that Oracle11g is known to be available is-Automatic Memory Management

Oracle introduced automatic PGA adjustment in Oracle9i; introduced automatic SGA adjustment in Oracle10g; and In 11g, Oracle can automatically adjust all memory usage by setting a parameter, this is called Automatic Memory Management ).
If this feature is abbreviated as AMM, Oracle already has:

ASSM
ASM
AMM
AUM
ADDM
AWR
......

This newly introduced parameter is said to be: MEMORY_TARGET

Oracle has several major targets in memory management:
SGA_TARGET
PGA_AGGREGATE_TARGET
MEMORY_TARGET

The MEMORY_TARGET parameter will eventually free the DBA from memory management.

The original English text is as follows:

MEMORY_TARGETSpecifies the Oracle system-wide usable memory. The database tunes memory to the MEMORY_TARGET value, clustering or enlarging the SGA and PGA as needed.

In a text initialization parameter file, if you omit the line for MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, the database automatically sets MEMORY_MAX_TARGET to the value of MEMORY_TARGET. if you omit the line for MEMORY_TARGET and include a value for MEMORY_MAX_TARGET, the MEMORY_TARGET parameter defaults to zero. after startup, you can then dynamically change MEMORY_TARGET to a non-zero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.

We can only say that Oracle is becoming more and more automated. In terms of ease of use, Oracle's unremitting efforts are indeed eye-catching.

-The End-