Oracle 10G sga 영역 설정 변경하기

<Oracle 10G sga 영역 설정 변경하기>

C:/> sqlplus sys as sysdba
SQL> show parameter sga
NAME                        TYPE                     VALUE
-------------------------   ----------------------   ------------------------
lock_sga                    boolean                  FALSE
pre_page_sga          boolean                  FALSE
sga_max_size          big integer              610M
sga_target                 big integer              610M
SQL> show sga
Total System Global Area  167772160 bytes
Fixed Size                                  1247876 bytes
Variable Size                          71304572 bytes
Database Buffers                  88080384 bytes
Redo Buffers                            7139328 bytes

SQL> alter system set sga_target=160M scope=both;

--> 에러가 날수 있음. 하지만  아래 명령어로 sga_target 이 설정되어있나 확인하면됨. 타겟이 설정되어있으면 됨
SQL> show parameter sga

NAME                        TYPE                     VALUE
-------------------------   ----------------------   ------------------------
lock_sga                    boolean                  FALSE
pre_page_sga          boolean                  FALSE
sga_max_size          big integer              610M
sga_target                 big integer              160M

SQL> shutdown immediate
후 시작해보면 변경된 부분 확인가능.