TABLESPACE, DATAFILES, ASM DISKGROUP IN ORACLE SQL QUERIES

For checking asm disk group :-

su - oragrid

sqlplus / as sysasm 

 tablespace,datafiles,asm,etc 
gv$filespace_usage RAC view;
v$filespace_usage view;

dba_tablespace_usage_metrics view:- 
dba_hist_tbspc_space_usage AWR tablespace :-

SELECT name ,round(bytes/power(1024,3),2)  size_gb
FROM   v$datafile where name like '+INSTANCE_ORADATA%'   order by size_gb desc;
desc v$datafile;

select count(round(bytes/power(1024,3),2)) count,sum(round(bytes/power(1024,3),2)) size_gb 
from v$datafile 
where 
round(bytes/power(1024,3),2) >=10 and round(bytes/power(1024,3),2) < 32 and name like '+INSTANCE_ORADATA%';

select sum(round(bytes/power(1024,3),2)) size_gb from v$datafile where name like '+INSTANCE_ORADATA%';

select
   tablespace_name,
   round(used_percent,2) used_percent
from
   dba_tablespace_usage_metrics;

   
desc gv$asm_diskgroup;

select name,round(total_mb/power(1023,2),2) from gv$asm_diskgroup;

select distinct name,round(total_mb/power(1024,1)) total_size_GB,round(free_mb/power(1024,1)) free_size_GB,
round(round(free_mb/power(1024,1),2)/round(total_mb/power(1024,1),2)*100) percent_free,state from gv$asm_diskgroup;
--where name like '%INSTANCE_ORADATA%';

--- free space in asm diskgroup ---
select distinct name,round(total_mb/power(1024,1)) total_size_GB,round(free_mb/power(1024,1)) free_size_GB,
round(round(free_mb/power(1024,1),2)/round(total_mb/power(1024,1),2)*100) percent_free,
(round((total_mb - free_mb)/power(1024,1),2)) USED_GB
,state from gv$asm_diskgroup;
   
select ts.tablespace_name,df.name from dba_tablespace_usage_metrics ts inner join  v$datafile df on df.name is not null where df.name like 
'+INSTANCE_ORADATA%';

select distinct
a.name Name,
round(a.bytes/power(1024,3),2) size_GB,
b.phyrds,
b.phywrts
from gv$datafile a, gv$filestat b
where a.file# = b.file#
order by size_GB desc;