Oracle11gSGA Adjustment Method

Oracle11g modify sga to modify memory_target and other parameters first, otherwise the service will be restarted with an error ORA-00844: Parameter not taking MEMORY_TARGET into account, see alert log for mo
Re information.
 
To modify the SGA principles, follow these steps:
1. sga_target cannot be greater than sga_max_size. It can be set to equal.
2. The total memory occupied by other processes such as SGA and PGA must be smaller than the physical memory of the operating system.
 
The specific commands are as follows:
 
 
Microsoft Windows [version 6.0.6002]
Copyright (C) 2006 Microsoft Corporation. All rights reserved.
 
C: \ Users \ Administrator> sqlplus/nolog
 
SQL * Plus: Release 11.1.0.6.0-Production on Wednesday February 22 10:51:08 2012
 
Copyright (c) 1982,200 7, Oracle. All rights reserved.
 
SQL> conn sys/sys as sysdba;
Connected.
SQL> show sga;
 
Total System Global Area 631926784 bytes
Fixed Size 1334996 bytes
Variable Size 205521196 bytes
Database Buffers 419430400 bytes
Redo Buffers 5640192 bytes
SQL> alter system set memory_max_target = 700 m scope = spfile;
 
The system has been changed.
 
SQL> alter system set memory_target = 700 m scope = spfile;
 
The system has been changed.
 
SQL> show sga;
 
Total System Global Area 631926784 bytes
Fixed Size 1334996 bytes
Variable Size 205521196 bytes
Database Buffers 419430400 bytes
Redo Buffers 5640192 bytes
SQL> shutdown immediate;
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup;
The ORACLE routine has been started.
 
Total System Global Area 631926784 bytes
Fixed Size 1334996 bytes
Variable Size 205521196 bytes
Database Buffers 419430400 bytes
Redo Buffers 5640192 bytes
The database has been loaded.
The database has been opened.
 
SQL> alter system set sga_target = 650 m scope = spfile;
 
The system has been changed.
 
SQL> alter system set sga_max_size = 650 m scope = spfile;
 
The system has been changed.
 
SQL> shutdown immediate;
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup;
The ORACLE routine has been started.
 
Total System Global Area 686329856 bytes
Fixed Size 1335360 bytes
Variable Size 205524928 bytes
Database Buffers 473956352 bytes
Redo Buffers 5513216 bytes
The database has been loaded.
The database has been opened.
SQL> show sga;
 
Total System Global Area 686329856 bytes
Fixed Size 1335360 bytes
Variable Size 205524928 bytes
Database Buffers 473956352 bytes
Redo Buffers 5513216 bytes
 
Appendix: ora-00844 error Solution:
 
 
SQL> create pfile = 'C: \ inittest. ora 'from spfile;
 
The file has been created.
<Span style = "color: # ff6666;"> (manually modify the corresponding memory_target parameter in the file) </span>
SQL> startup pfile = 'C: \ inittest. ora ';
The ORACLE routine has been started.
 
Total System Global Area 631926784 bytes
Fixed Size 1334996 bytes
Variable Size 205521196 bytes
Database Buffers 419430400 bytes
Redo Buffers 5640192 bytes
The database has been loaded.
The database has been opened.
SQL> create spfile from pfile = 'C: \ inittest. ora ';
 
The file has been created.
 
SQL> shutdown immediate;
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup;
The ORACLE routine has been started.
 
Total System Global Area 631926784 bytes
Fixed Size 1334996 bytes
Variable Size 205521196 bytes
Database Buffers 419430400 bytes
Redo Buffers 5640192 bytes
The database has been loaded.
The database has been opened.
 
From column qb371