ASMの動的パフォーマンスビューの一覧

ASMの代表的な動的パフォーマンスビューの一覧とその構成です。

ASM動的パフォーマンスビュー

v$asm_alias
v$asm_client
v$asm_disk
v$asm_diskgroup
v$asm_file
v$asm_operation

v$asm_alias

select NAME,GROUP_NUMBER,FILE_NUMBER,FILE_INCARNATION,ALIAS_INDEX,ALIAS_INCARNATION,PARENT_INDEX,REFERENCE_INDEX,ALIAS_DIRECTORY,SYSTEM_CREATED from v$asm_alias;

SQL> desc v$asm_alias
 名前                          NULL?    型
 ----------------------------- -------- ----------------------
 NAME                                   VARCHAR2(70)
 GROUP_NUMBER                           NUMBER
 FILE_NUMBER                            NUMBER
 FILE_INCARNATION                       NUMBER
 ALIAS_INDEX                            NUMBER
 ALIAS_INCARNATION                      NUMBER
 PARENT_INDEX                           NUMBER
 REFERENCE_INDEX                        NUMBER
 ALIAS_DIRECTORY                        VARCHAR2(1)
 SYSTEM_CREATED                         VARCHAR2(1)

SQL>

v$asm_client

select GROUP_NUMBER,INSTANCE_NAME,DB_NAME,STATUS,SOFTWARE_VERSION,COMPATIBLE_VERSION from v$asm_client;

SQL> desc v$asm_client
 名前                          NULL?    型
 ----------------------------- -------- ----------------------
 GROUP_NUMBER                           NUMBER
 INSTANCE_NAME                          VARCHAR2(64)
 DB_NAME                                VARCHAR2(8)
 STATUS                                 VARCHAR2(12)
 SOFTWARE_VERSION                       VARCHAR2(60)
 COMPATIBLE_VERSION                     VARCHAR2(60)

SQL>

v$asm_disk

select GROUP_NUMBER,DISK_NUMBER,COMPOUND_INDEX,INCARNATION,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,REDUNDANCY,LIBRARY,OS_MB,TOTAL_MB,FREE_MB,HOT_USED_MB,COLD_USED_MB,NAME,FAILGROUP,LABEL,PATH,UDID,PRODUCT,CREATE_DATE,MOUNT_DATE,REPAIR_TIMER,READS,WRITES,READ_ERRS,WRITE_ERRS,READ_TIME,WRITE_TIME,BYTES_READ,BYTES_WRITTEN,PREFERRED_READ,HASH_VALUE,HOT_READS,HOT_WRITES,HOT_BYTES_READ,HOT_BYTES_WRITTEN,COLD_READS,COLD_WRITES,COLD_BYTES_READ,COLD_BYTES_WRITTEN,VOTING_FILE,SECTOR_SIZE,FAILGROUP_TYPE from v$asm_disk;

SQL> desc v$asm_disk
 名前                          NULL?    型
 ----------------------------- -------- ----------------------
 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>

v$asm_diskgroup

select GROUP_NUMBER,NAME,SECTOR_SIZE,BLOCK_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,TOTAL_MB,FREE_MB,HOT_USED_MB,COLD_USED_MB,REQUIRED_MIRROR_FREE_MB,USABLE_FILE_MB,OFFLINE_DISKS,COMPATIBILITY,DATABASE_COMPATIBILITY,VOTING_FILES from v$asm_diskgroup;

SQL> desc v$asm_diskgroup
 名前                          NULL?    型
 ----------------------------- -------- ----------------------
 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>

v$asm_file

select GROUP_NUMBER,FILE_NUMBER,COMPOUND_INDEX,INCARNATION,BLOCK_SIZE,BLOCKS,BYTES,SPACE,TYPE,REDUNDANCY,STRIPED,CREATION_DATE,MODIFICATION_DATE,REDUNDANCY_LOWERED,PERMISSIONS,USER_NUMBER,USER_INCARNATION,USERGROUP_NUMBER,USERGROUP_INCARNATION,PRIMARY_REGION,MIRROR_REGION,HOT_READS,HOT_WRITES,HOT_BYTES_READ,HOT_BYTES_WRITTEN,COLD_READS,COLD_WRITES,COLD_BYTES_READ,COLD_BYTES_WRITTEN from v$asm_file;

SQL> desc v$asm_file
 名前                          NULL?    型
 ----------------------------- -------- ----------------------
 GROUP_NUMBER                           NUMBER
 FILE_NUMBER                            NUMBER
 COMPOUND_INDEX                         NUMBER
 INCARNATION                            NUMBER
 BLOCK_SIZE                             NUMBER
 BLOCKS                                 NUMBER
 BYTES                                  NUMBER
 SPACE                                  NUMBER
 TYPE                                   VARCHAR2(64)
 REDUNDANCY                             VARCHAR2(6)
 STRIPED                                VARCHAR2(6)
 CREATION_DATE                          DATE
 MODIFICATION_DATE                      DATE
 REDUNDANCY_LOWERED                     VARCHAR2(1)
 PERMISSIONS                            VARCHAR2(16)
 USER_NUMBER                            NUMBER
 USER_INCARNATION                       NUMBER
 USERGROUP_NUMBER                       NUMBER
 USERGROUP_INCARNATION                  NUMBER
 PRIMARY_REGION                         VARCHAR2(4)
 MIRROR_REGION                          VARCHAR2(4)
 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

SQL>

v$asm_operation

select GROUP_NUMBER,OPERATION,STATE,POWER,ACTUAL,SOFAR,EST_WORK,EST_RATE,EST_MINUTES,ERROR_CODE from v$asm_operation;

SQL> desc v$asm_operation
 名前                          NULL?    型
 ----------------------------- -------- ----------------------
 GROUP_NUMBER                           NUMBER
 OPERATION                              CHAR(5)
 STATE                                  VARCHAR2(4)
 POWER                                  NUMBER
 ACTUAL                                 NUMBER
 SOFAR                                  NUMBER
 EST_WORK                               NUMBER
 EST_RATE                               NUMBER
 EST_MINUTES                            NUMBER
 ERROR_CODE                             VARCHAR2(44)

SQL>

Tweet