ASM - alle ASM disk groups samen met hun performance metrics
Overzicht van alle disks binnen alle ASM disk groups samen met hun performance metrics
SET LINESIZE  145
SET PAGESIZE 9999
SET VERIFY off

COLUMN disk_group_name FORMAT a20 HEAD 'Disk Group Name'
COLUMN disk_path FORMAT a20 HEAD 'Disk Path'
COLUMN reads FORMAT 999,999,999 HEAD 'Reads'
COLUMN writes FORMAT 999,999,999 HEAD 'Writes'
COLUMN read_errs FORMAT 999,999 HEAD 'Read|Errors'
COLUMN write_errs FORMAT 999,999 HEAD 'Write|Errors'
COLUMN read_time FORMAT 999,999,999 HEAD 'Read|Time'
COLUMN write_time FORMAT 999,999,999 HEAD 'Write|Time'
COLUMN bytes_read FORMAT 999,999,999,999 HEAD 'Bytes|Read'
COLUMN bytes_written FORMAT 999,999,999,999 HEAD 'Bytes|Written'

break on report on disk_group_name skip 2

compute sum label "" of reads writes read_errs write_errs read_time
write_time bytes_read bytes_written on disk_group_name
compute sum label "Grand Total: " of reads writes read_errs write_errs read_time
write_time bytes_read bytes_written on report

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
/
 

Advertentie

>

Poll

Voorkeur
 

Wie is er aanwezig

We hebben 85 gasten online