[Oracle Script] ASM Disks Performance metric
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
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
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。