_ksmg_granule_size oracle內存分配粒度

_ksmg_granule_size:

內存分配粒度大小

oracle內存分配的最小單位，最終分配的內存數量都是這個參

數的整數倍

10g中這個參數的大小一般遵循如下原則：

– sga_max_size < = 1024M then _ksmg_granule_size = 4M

- sga_max_size > 1024M then _ksmg_granule_size = 16M

SQL> show parameter sga

NAME???????????????????????????????? TYPE??????? VALUE

------------------------------------ ----------- -----

-------------------------

sga_max_size???????????????????????? big integer 164M

sga_target?????????????????????????? big integer 0

SQL> select x.ksppinm name,y.ksppstvl value,x.ksppdesc

descbtion

2? from x$ksppi x,x$ksppcv y

3? where x.inst_id=userenv('Instance')

4? and y.inst_id=userenv('Instance')

5? and x.indx=y.indx

6? and x.ksppinm like '%_ksmg_granule%';

rows will be truncated

NAME???????????????????????????? VALUE

-------------------------------- ---------------------

-----

_ksmg_granule_size?????????????? 4194304

SQL> show parameter sga

NAME???????????????????????????????? TYPE??????? VALUE

------------------------------------ ----------- -----

-------------------------

lock_sga???????????????????????????? boolean???? FALSE

pre_page_sga???????????????????????? boolean???? FALSE

sga_max_size???????????????????????? big integer 18000M

sga_target?????????????????????????? big integer 18000M

SQL> select x.ksppinm name,y.ksppstvl value,x.ksppdesc

descbtion

2? from x$ksppi x,x$ksppcv y

3? where x.inst_id=userenv('Instance')

4? and y.inst_id=userenv('Instance')

5? and x.indx=y.indx

6? and x.ksppinm like '%_ksmg_granule%';

NAME?????????????????????????? VALUE

------------------------------

_ksmg_granule_size???????????? 16777216

----------------------------------

這個參數調整并不是任意的，還受到sga總量的限制，如果sga

不夠，即使調整參數也不會生效，只能調整到系統能夠認到的

最大值

SQL> alter system set "_ksmg_granule_size"=16777216

scope=spfile;

System altered.

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area? 176160768 bytes

Fixed Size?????????????????? 787588 bytes

Variable Size???????????? 149683068 bytes

Database Buffers?????????? 25165824 bytes

Redo Buffers???????????????? 524288 bytes

Database mounted.

Database opened.

SQL> select x.ksppinm name,y.ksppstvl value,x.ksppdesc

descbtion

2? from x$ksppi x,x$ksppcv y

3? where x.inst_id=userenv('Instance')

4? and y.inst_id=userenv('Instance')

5? and x.indx=y.indx

6? and x.ksppinm like '%_ksmg_granule%';

rows will be truncated

NAME

VALUE

------------------------------------------------------

-------------------------- --------------------------

_ksmg_granule_size

8388608

因為本地內存太小，并沒有調整到16m，而是8m

創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的granule size oracle,_ksmg_granule_size oracle内存分配粒度的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。