INSTANCE_TYPE:ASM實(shí)例要求此參數(shù)為ASM,隱含著將DB_UNIQUE_NAME設(shè)置為 ASM.ASM_DISKSTRING:指定在磁盤發(fā)現(xiàn)過(guò)程應(yīng)當(dāng)查找的位置,默認(rèn)值是NULL。ASM_DISKGROUPS:指定在實(shí)例啟動(dòng)時(shí)要自動(dòng)裝載的磁盤組的名稱,默認(rèn)值是NULL。
ASM在分配空間時(shí),以AU為單位進(jìn)行,AU即Allocation units,是組成ASM disk的基本單元。
在Oracle 10gR2中,ASM AU的缺省單位大小是1M,相應(yīng)的條帶大小是128K。在ASM中,可以通過(guò)調(diào)整_asm_ausize隱含參數(shù)的大小來(lái)進(jìn)行調(diào)整,_asm_stripesize控制相應(yīng)的條帶化參數(shù)。
從v$asm_diskgroup視圖可以查詢得到相關(guān)的信息:
SQL> select group_number,name,sector_size,block_size,allocation_unit_size from v$asm_diskgroup;
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE———— —— ———– ———- ——————– 1 ARCHDG 512 4096 1048576 2 DATADG 512 4096 1048576在Oracle Database 11g中,可以通過(guò)類似如下語(yǔ)句在創(chuàng)建磁盤組時(shí)指定au_size:SQL> CREATE DISKGROUP DATA DISK \\\’/dev/raw/raw15\\\’, \\\’/dev/raw/raw16\\\’,\\\’/dev/raw/raw17\\\’ ATTRIBUTE \\\’au_size\\\’ = \\\’16M\\\’, \\\’compatible.asm\\\’ = \\\’11.1\\\’ \\\’compatible.rdbms\\\’ = \\\’11.1\\\’;ASM允許的相關(guān)參數(shù)可以從DB的實(shí)例中查詢獲得,以下是一系列和asm相關(guān)的初始化參數(shù):SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ FROM SYS.x$ksppi x, SYS.x$ksppcv y WHERE x.indx = y.indx AND x.ksppinm LIKE \\\’%asm%\\\’;
NAME VALUE DESCRIB—————————— ——————– ————————————————————asm_diskstring disk set locations for discovery_asm_disk_repair_time 14400 seconds to wait before dropping a failing diskasm_diskgroups disk groups to mount automaticallyasm_power_limit 1 number of processes for disk rebalancing_asm_ausize 1048576 allocation unit size_asm_blksize 4096 metadata block size_asm_acd_chunks 1 initial ACD chunks created_asm_libraries ufs library search order for discovery_asm_maxio 1048576 Maximum size of individual I/O request_asm_allow_only_raw_disks TRUE Discovery only raw devices_asmlib_test 0 Osmlib test event_asm_allow_resilver_corruption FALSE Enable disk resilvering for external redundancy_asmsid asm ASM instance id_asm_wait_time 18 Max/imum time to wait before asmb exits_asm_stripewidth 8 ASM file stripe width_asm_stripesize 131072 ASM file stripe size_asm_droptimeout 60 timeout before offlined disks get dropped (in 3s ticks)_asm_emulmax 10000 max number of concurrent disks to emulate I/O errors_asm_emultimeout 0 timeout before emulation begins (in 3s ticks)_asm_kfdpevent 0 KFDP event
20 rows selected.
更多關(guān)于云服務(wù)器,域名注冊(cè),虛擬主機(jī)的問(wèn)題,請(qǐng)?jiān)L問(wèn)西部數(shù)碼官網(wǎng):m.ps-sw.cn