V$ASM_DISK definition in Oracle Database 11.2
V$ASM_DISK

select
  group_number,                            -- GROUP_NUMBER NUMBER
  disk_number,                             -- DISK_NUMBER NUMBER
  compound_index,                          -- COMPOUND_INDEX NUMBER
  incarnation,                             -- INCARNATION NUMBER
  mount_status,                            -- MOUNT_STATUS VARCHAR2(7)
  header_status,                           -- HEADER_STATUS VARCHAR2(12)
  mode_status,                             -- MODE_STATUS VARCHAR2(7)
  state,                                   -- STATE VARCHAR2(8)
  redundancy,                              -- REDUNDANCY VARCHAR2(7)
  library,                                 -- LIBRARY VARCHAR2(64)
  os_mb,                                   -- OS_MB NUMBER
  total_mb,                                -- TOTAL_MB NUMBER
  free_mb,                                 -- FREE_MB NUMBER
  hot_used_mb,                             -- HOT_USED_MB NUMBER
  cold_used_mb,                            -- COLD_USED_MB NUMBER
  name,                                    -- NAME VARCHAR2(30)
  failgroup,                               -- FAILGROUP VARCHAR2(30)
  label,                                   -- LABEL VARCHAR2(31)
  path,                                    -- PATH VARCHAR2(256)
  udid,                                    -- UDID VARCHAR2(64)
  product,                                 -- PRODUCT VARCHAR2(32)
  create_date,                             -- CREATE_DATE DATE
  mount_date,                              -- MOUNT_DATE DATE
  repair_timer,                            -- REPAIR_TIMER NUMBER
  reads,                                   -- READS NUMBER
  writes,                                  -- WRITES NUMBER
  read_errs,                               -- READ_ERRS NUMBER
  write_errs,                              -- WRITE_ERRS NUMBER
  read_time,                               -- READ_TIME NUMBER
  write_time,                              -- WRITE_TIME NUMBER
  bytes_read,                              -- BYTES_READ NUMBER
  bytes_written,                           -- BYTES_WRITTEN NUMBER
  preferred_read,                          -- PREFERRED_READ VARCHAR2(1)
  hash_value,                              -- HASH_VALUE NUMBER
  hot_reads,                               -- HOT_READS NUMBER
  hot_writes,                              -- HOT_WRITES NUMBER
  hot_bytes_read,                          -- HOT_BYTES_READ NUMBER
  hot_bytes_written,                       -- HOT_BYTES_WRITTEN NUMBER
  cold_reads,                              -- COLD_READS NUMBER
  cold_writes,                             -- COLD_WRITES NUMBER
  cold_bytes_read,                         -- COLD_BYTES_READ NUMBER
  cold_bytes_written,                      -- COLD_BYTES_WRITTEN NUMBER
  voting_file,                             -- VOTING_FILE VARCHAR2(1)
  sector_size,                             -- SECTOR_SIZE NUMBER
  failgroup_type                           -- FAILGROUP_TYPE VARCHAR2(7)
from
  gv$asm_disk
where
  inst_id = USERENV('Instance')

home |  up