Previous Topic

Next Topic

Book Contents

Required parameters when Automatic Memory Tuning is on

Set the following required initialization parameters.

Database parameters required when Automatic Memory Tuning is on

Parameter

Production servers

Development
servers

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.