sql/asmdsu.sql at master · JAC2703/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
43
44
45
46
47
48
49
50
--******************************************************************************
--*
--*  Description
--*  ***********
--*
--*  File:    asmdsu.sql
--*
--*  Description: This script shows ASM Disk status.
--*
--* ----------------------------------------------------------------------------
--* Date         Author             Description
--* ===========  =================  ============================================
--* 03-JUN-2013  Jeff Moss          Created
--*

SET WRAP OFF
SET LINESIZE 200
SET PAGESIZE 10000
COLUMN inst_id HEADING "Inst|ID" FORMAT 999
COLUMN group_number FORMAT 999 HEADING "Grp|#"
COLUMN disk_number FORMAT 999 HEADING "Dsk|#"
COLUMN header_status FORMAT a9 HEADING "Header|Status"
COLUMN mode_status FORMAT a8 HEADING "Mode|Status"
COLUMN state FORMAT a8 HEADING "State"
COLUMN create_date FORMAT a10 HEADING "Create|Date"
COLUMN redundancy FORMAT a10 HEADING "Redundancy"
COLUMN failgroup FORMAT a10 HEADING "Failure|Group"
COLUMN path FORMAT a30 HEADING "Path"
COLUMN total_gb FORMAT 999,999 HEADING "Total|GB"
COLUMN free_gb FORMAT 999,999 HEADING "Free|GB"
COLUMN name FORMAT a30 HEADING "Disk|Name"

SELECT inst_id
,      path
,      group_number
,      disk_number
,      header_status
,      mode_status
,      state
,      create_date
,      redundancy
,      (total_mb/1024) total_gb
,      (free_mb/1024) free_gb
,      name
,      failgroup
FROM   gv$asm_disk_stat
ORDER BY inst_id
,        group_number
,        disk_number
/