forked from abdulirfan3/Oracle_SQL_Scripts
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathasm_alias.sql
More file actions
40 lines (35 loc) · 1.67 KB
/
asm_alias.sql
File metadata and controls
40 lines (35 loc) · 1.67 KB
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
-- | PURPOSE : Provide a summary report of all alias definitions contained |
-- | within all ASM disk groups. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET PAGESIZE 9999
SET VERIFY off
COLUMN disk_group_name FORMAT a20 HEAD 'Disk Group Name'
COLUMN alias_name FORMAT a30 HEAD 'Alias Name'
COLUMN file_number HEAD 'File|Number'
COLUMN file_incarnation HEAD 'File|Incarnation'
COLUMN alias_index HEAD 'Alias|Index'
COLUMN alias_incarnation HEAD 'Alias|Incarnation'
COLUMN parent_index HEAD 'Parent|Index'
COLUMN reference_index HEAD 'Reference|Index'
COLUMN alias_directory FORMAT a10 HEAD 'Alias|Directory?'
COLUMN system_created FORMAT a8 HEAD 'System|Created?'
break on report on disk_group_name skip 1
SELECT
g.name disk_group_name
, a.name alias_name
, a.file_number file_number
, a.file_incarnation file_incarnation
, a.alias_index alias_index
, a.alias_incarnation alias_incarnation
, a.parent_index parent_index
, a.reference_index reference_index
, a.alias_directory alias_directory
, a.system_created system_created
FROM
v$asm_alias a JOIN v$asm_diskgroup g USING (group_number)
ORDER BY
g.name
, a.file_number
/