Oracle 10g modify SGA_TARGET

Oracle 10g modify SGA_TARGET

In Oracle10g, Oracle introduced the sga_target initialization parameter to implement ASMM (Automatic Shared Memory Management), that is, set the target value of an SGA and the maximum value of SGA, database to dynamically adjust various components, such as Database buffer cache and Shared pool. From the perspective of usage, the appearance of ASMM greatly simplifies the setting of Oracle memory initialization parameters. There is no big difference between advanced DBA and beginners in the use of ASMM. However, while being convenient, ASMM is a black box with many secrets hidden in it. These secrets Bring more uncertainty than manual management.

Next, let's take a look at how to modify the size of the sga_target initialization parameter.

1. Test Environment

We tested it in Oracle10g. The operating system is Windows Server 2008 R2 Standard.

• SQL>
• SQL>