Set the following required initialization parameters.
Database parameters required when Automatic Memory Tuning is on
Parameter |
Production servers |
Development |
---|---|---|
SGA_MAX_SIZE* |
584M |
584M |
SGA_TARGET |
Equal to or less than SGA_MAX_SIZE |
Equal to or less than SGA_MAX_SIZE |
CHARACTER_SET |
AL32UTF8 |
AL32UTF8 |
NATIONAL_CHARACTER_SET |
AL16UTF16 |
AL16UTF16 |
* SGA_MAX_SIZE can be set based on the system available resource. It can be set up to 80% of the system memory for a dedicated server.
Copyright © 2002, 2016 Oracle and/or its affiliates. All rights reserved.