Tablespace Segment Report

Hi Guys

I know there are different ways to achieved a Tablespace segment Report  base on my scenario with BIG file tablespaces with  BLOBs, CLOBs segment I've been working on this query

$ORACLE_HOME/bin/sqlplus -s -l " / as sysdba" << EOF > segment_report.html

SET ECHO OFF

SET FEEDBACK OFF

SET VERIFY OFF

set pages 999

set lines 480

set long 99999

SET MARKUP HTML ON spool on PREFORMAT OFF

ttitle "Tablespace SEgment Sized report in $ORACLE_SID"

SELECT

tablespace_name

,segment_name "Table Name"

--,segment_type

,owner

,sum(bytes)/(1024*1024*1024) Gbytes

from dba_segments

where segment_type IN ('TABLE', 'TABLE PARTITION')

group by tablespace_name, segment_name, owner