sql/asm_disks.sql at master · jpsaraiva/sql · GitHub

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
31
32
33
34
35
36
37
38
39
40
41
42
----------------------------------------------------------------------------------------
--
-- File name: asm_disks.sql
--
-- Purpose: List all ASM disks
--
-- Author: jpsaraiva
--
-- Version: 2017/02/20
--
-- Example: @asm_disks.sql
--
-- Notes: Developed and tested on 11.2.0.4.
--
---------------------------------------------------------------------------------------
--

set pagesize 100 lines 120 pages 1000 heading on feed off null '' ver off

set pages 4000
set lines 220
col path for a30
col gn for 999
col dn for 999
col "DG NAME" format a30
col "DISK NAME" format a30
col name for a15
SELECT
     group_number gn
    ,disk_number dn
    ,name
    ,os_mb
    --,compound_index
    --,incarnation
    ,mount_status
    ,header_status
    ,mode_status
    ,state
    ,redundancy
    ,path
  FROM v$asm_disk
order by name;