| Property | Description |
|---|---|
| Parameter type | Big integer |
| Syntax | MEMORY_TARGET = integer [K | M | G] |
| Default value | 0 |
| Modifiable | ALTER SYSTEM |
| Range of values | 152 MB to MEMORY_MAX_TARGET |
| Basic | No |
MEMORY_TARGET specifies the Oracle system-wide usable memory. The database tunes memory to the MEMORY_TARGET value, reducing or enlarging the SGA and PGA as needed.
In a text-based initialization parameter file, if you omit MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, then 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 nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.
See Also:
Oracle Database Administrator's Guide for more information about managing memory