[Oracle Script] ASM Disks Performance metric

tolilong發表於2017-10-15
ASM Disks Performance metric:
SELECT a.name          disk_group_name,
       b.path          disk_path,
       b.reads         reads,
       b.writes        writes,
       b.read_errs     read_errs,
       b.write_errs    write_errs,
       b.read_time     read_time,
       b.write_time    write_time,
       b.bytes_read    bytes_read,
       b.bytes_written bytes_written
  FROM v$asm_diskgroup a
  JOIN v$asm_disk b
 USING (group_number)
 ORDER BY a.name

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2145992/,如需轉載,請註明出處,否則將追究法律責任。

相關文章