19.4 - tablespaces tab in DBA view - TEMP tablespaces show wrong values in RAC database

Hi,

Kindly check the below query,

To check instance-wise total allocated, total used TEMP,

set lines 152

col FreeSpaceGB format 999.999

col UsedSpaceGB format 999.999

col TotalSpaceGB format 999.999

col host_name format a30

col tablespace_name format a30

select tablespace_name,

(free_blocks*8)/1024/1024 FreeSpaceGB,

(used_blocks*8)/1024/1024 UsedSpaceGB,

(total_blocks*8)/1024/1024 TotalSpaceGB,

1. i.instance_name,i.host_name

from gv$sort_segment ss,gv$instance i where ss.tablespace_name in (select tablespace_name from dba_tablespaces where contents='TEMPORARY') and

1. i.inst_id=ss.inst_id;

http://allappsdba.blogspot.com/2012/04/scripts-related-to-temp-tablespace.html