Oracle ASM学习之（1）--ASM Instance管理
SQL> desc v$asm_diskgroup;Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
NAME VARCHAR2(30)
SECTOR_SIZE NUMBER
BLOCK_SIZE NUMBER
ALLOCATION_UNIT_SIZE NUMBER
STATE VARCHAR2(11)
TYPE VARCHAR2(6)
TOTAL_MB NUMBER
FREE_MB NUMBER
HOT_USED_MB NUMBER
COLD_USED_MB NUMBER
REQUIRED_MIRROR_FREE_MB NUMBER
USABLE_FILE_MB NUMBER
OFFLINE_DISKS NUMBER
COMPATIBILITY VARCHAR2(60)
DATABASE_COMPATIBILITY VARCHAR2(60)
VOTING_FILES VARCHAR2(1)
SQL> col name for a10
SQL>select GROUP_NUMBER,NAME,ALLOCATION_UNIT_SIZE,STATE,TOTAL_MB,FREE_MB from v$asm_diskgroup
GROUP_NUMBER NAME ALLOCATION_UNIT_SIZE STATE TOTAL_MB FREE_MB
------------ ---------- -------------------- ----------- ---------- ----------
1 OCR_VOTE 1048576 MOUNTED 2892 1966
2 DG1 1048576 MOUNTED 9554 5854
3 RCY1 1048576 MOUNTED 5740 5070
SQL> desc v$asm_disk;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP_NUMBER NUMBER
DISK_NUMBER NUMBER
COMPOUND_INDEX NUMBER
INCARNATION NUMBER
MOUNT_STATUS VARCHAR2(7)
HEADER_STATUS VARCHAR2(12)
MODE_STATUS VARCHAR2(7)
STATE VARCHAR2(8)
REDUNDANCY VARCHAR2(7)
LIBRARY VARCHAR2(64)
OS_MB NUMBER
TOTAL_MB NUMBER
FREE_MB NUMBER
HOT_USED_MB NUMBER
COLD_USED_MB NUMBER
NAME VARCHAR2(30)
FAILGROUP VARCHAR2(30)
LABEL VARCHAR2(31)
PATH VARCHAR2(256)
UDID VARCHAR2(64)
PRODUCT VARCHAR2(32)
CREATE_DATE DATE
MOUNT_DATE DATE
REPAIR_TIMER NUMBER
READS NUMBER
WRITES NUMBER
READ_ERRS NUMBER
WRITE_ERRS NUMBER
READ_TIME NUMBER
WRITE_TIME NUMBER
BYTES_READ NUMBER
BYTES_WRITTEN NUMBER
PREFERRED_READ VARCHAR2(1)
HASH_VALUE NUMBER
HOT_READS NUMBER
HOT_WRITES NUMBER
HOT_BYTES_READ NUMBER
HOT_BYTES_WRITTEN NUMBER
COLD_READS NUMBER
COLD_WRITES NUMBER
COLD_BYTES_READ NUMBER
COLD_BYTES_WRITTEN NUMBER
VOTING_FILE VARCHAR2(1)
SECTOR_SIZE NUMBER
FAILGROUP_TYPE VARCHAR2(7)
SQL> select GROUP_NUMBER,DISK_NUMBER,NAME ,PATH,FAILGROUP,FREE_MB from v$asm_disk
GROUP_NUMBER DISK_NUMBER NAME PATH FAILGROUP FREE_MB
------------ ----------- ---------- ------------------------------ ------------------------------ ----------
2 0 ASM_DATA1ORCL:ASM_DATA1 ASM_DATA1 2927
2 1 ASM_DATA2ORCL:ASM_DATA2 ASM_DATA2 2927
3 0 ASM_RCY1 ORCL:ASM_RCY1 ASM_RCY1 2535
3 1 ASM_RCY2 ORCL:ASM_RCY2 ASM_RCY2 2535
1 0 OCR_VOTE1ORCL:OCR_VOTE1 OCR_VOTE1 655
1 1 OCR_VOTE2ORCL:OCR_VOTE2 OCR_VOTE2 656
1 2 OCR_VOTE3ORCL:OCR_VOTE3 OCR_VOTE3 655
7 rows selected.
页:
[1]