SGA Memory > Physical Memory 가능함 [ SWAP 에 따른 성능 저하 ]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 | [TGSVR]TGSVR15:/app/oracle> sqlplus '/as sysdba' SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 13 16:43:50 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> show parameters spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /app/oracle/product/12.1.0.2/d bs/spfileTGSVR.ora SQL> show parameters sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 2352M sga_target big integer 2352M unified_audit_sga_queue_size integer 1048576 SQL> create pfile from spfile ; File created. SQL> alter system set sga_max_size=10G scope=spfile ; System altered. SQL> alter system set sga_target=10G scope=spfile ; System altered. SQL> select * from global_name ; GLOBAL_NAME -------------------------------------------------------------------------------- TGSVR SQL> shutdown immediate ; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 1.0737E+10 bytes Fixed Size 2935712 bytes Variable Size 2214593632 bytes Database Buffers 8489271296 bytes Redo Buffers 30617600 bytes Database mounted. Database opened. --> 기동 되지만, 겁나 오래 걸림 메모리 할당하면서 오래 걸리는듯, 아래 swap size 고려해보면, SWAP 확보 시간 만큼 추가 되는듯 SQL> show parameters sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 10G sga_target big integer 10G unified_audit_sga_queue_size integer 1048576 -- 실제 물리 메모리가 8 기가 + SGA 를 10 기가로 설정함 SQL> !free -m total used free shared buffers cached Mem: 7824 7671 153 6814 0 189 -/+ buffers/cache: 7481 343 Swap: 16383 2070 14313 -- 원복 SQL> alter system set sga_max_size=3G scope=spfile ; System altered. SQL> alter system set sga_target=3G scope=spfile ; System altered. SQL> shutdown immediate ; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 3221225472 bytes Fixed Size 2929552 bytes Variable Size 1157631088 bytes Database Buffers 2046820352 bytes Redo Buffers 13844480 bytes Database mounted. Database opened. SQL> show parameters sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 3G sga_target big integer 3G unified_audit_sga_queue_size integer 1048576 | cs |