FilesExpand file tree

master

/

asm_disk_errors.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

30 lines (26 loc) · 676 Bytes

master

/

asm_disk_errors.sql

Copy path

Top

File metadata and controls

• Code
• Blame

30 lines (26 loc) · 676 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

-- asm_disk_errors.sql

-- 2016-05-17

-- Jared Still - [email protected]

set linesize 200 trimspool on

col inst_id head 'I#' format 99

col path format a80

col diskgroup_name format a10

col disk_name format a15

col disk_number head 'D#' format 999

select

io.inst_id

, dg.name diskgroup_name

, io.disk_number

, d.name disk_name

--, d.label

, d.read_errs

, d.write_errs

, d.path

from gv$ASM_DISK_IOSTAT io

join gv$asm_diskgroup dg on dg.inst_id = io.inst_id

and dg.group_number = io.group_number

join gv$asm_disk d on d.inst_id = io.inst_id

and d.group_number = io.group_number

-- use the where clause if too many rows

--where d.read_errs + d.write_errs > 0

/