--VIEWS DE INFORMAÇÕES BÁSICAS DO ASM
--Contains one row for every alias present in every disk group mounted by the Oracle ASM instance.
select * from V$ASM_ALIAS

--In an Oracle ASM instance, identifies databases using disk groups managed by the Oracle ASM instance.
--In a DB instance, contains information about the Oracle ASM instance if the database has any open Oracle ASM files.
select * from V$ASM_CLIENT

--Displays one row for each attribute defined. In addition to attributes specified by CREATE DISKGROUP and ALTER DISKGROUP statements, 
--the view may show other attributes that are created automatically. Attributes are only displayed for disk groups where COMPATIBLE.ASM is set to 11.1 or higher.
select * from V$ASM_ATTRIBUTE

--VIEWS DE MONITORAMENTO DOS DISCOS DO ASM
--Contains one row for every disk discovered by the Oracle ASM instance, including disks that are not part of any disk group.
select * from V$ASM_DISK

--Displays information about disk I/O statistics for each Oracle ASM client.
select * from V$ASM_DISK_IOSTAT	

--Contains the same columns as V$ASM_DISK, but to reduce overhead, does not perform a discovery when it is queried. 
--It only returns information about any disks that are part of mounted disk groups in the storage system. To see all disks, use V$ASM_DISK instead.
select * from V$ASM_DISK_STAT	

--Describes a disk group (number, name, size related info, state, and redundancy type).
select * from V$ASM_DISKGROUP

--Contains one row for every Oracle ASM file in every disk group mounted by the Oracle ASM instance.
select * from V$ASM_FILE

--The following query in the ASM instance gives the amount of bytes_read and bytes_written per database client and diskgroup, failgroup, path:
 select i.dbname, g.name diskgroup, i.failgroup, d.path, d.total_mb, i.bytes_read, i.bytes_written from v$asm_disk_iostat i, v$asm_diskgroup g, v$asm_disk d 
 where i.group_number=g.group_number and i.disk_number=d.disk_number and i.failgroup=d.failgroup order by i.dbname, g.name, i.failgroup, d.path;

-- VIEWS DIVERSAS
--In an Oracle ASM instance, contains one row for every active Oracle ASM long running operation executing in the Oracle ASM instance.
select * from V$ASM_OPERATION

--Contains one row for every template present in every disk group mounted by the Oracle ASM instance.
select * from V$ASM_TEMPLATE

--Contains the effective operating system user names of connected database instances and names of file owners.
select * from V$ASM_USER

--Contains the creator for each Oracle ASM File Access Control group.
select * from V$ASM_USERGROUP	

--Contains the members for each Oracle ASM File Access Control group.
select * from V$ASM_USERGROUP_MEMBER	


-- VIEWS DE MONITORAMENTO DO ACFS
select * from V$ASM_ACFSVOLUMES
select * from V$ASM_FILESYSTEM
select * from V$ASM_VOLUME
select * from V$ASM_VOLUME_STAT
select * from V$ASM_ACFSSNAPSHOTS