You can turn off Automatic Memory Tuning by setting SGA_TARGET to 0. If SGA_TARGET is set to 0, you must set the following initialization parameters:
Database parameters required when Automatic Memory Tuning is off
Parameter |
Production servers |
Development |
---|---|---|
SGA_Target |
0 |
0 |
DB_CACHE_SIZE |
17000 |
17000 |
SHARED_POOL_SIZE |
102400000 |
35000000 |
CHARACTER_SET |
AL32UTF8 |
AL32UTF8 |
NATIONAL_CHARACTER_SET |
AL16UTF16 |
AL16UTF16 |
Copyright © 2002, 2016 Oracle and/or its affiliates. All rights reserved.