Skip to content

Instantly share code, notes, and snippets.

@mjbommar
Created June 12, 2013 13:38
Show Gist options
  • Save mjbommar/5765312 to your computer and use it in GitHub Desktop.
Save mjbommar/5765312 to your computer and use it in GitHub Desktop.
Calculate the average KB per read or write for an Oracle ASM disk: http://bommaritollc.com/2013/06/12/plotting-average-read-and-write-operation-size-by-asm-disk
SELECT path, label, inst_id,
(bytes_read / DECODE(reads, 0, 1, reads)) / 1024. AS kb_per_read,
(bytes_written / DECODE(writes, 0, 1, writes)) / 1024. AS kb_per_write
FROM gv$asm_disk_stat
ORDER BY path, inst_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment