set echo off
set feedback off
set linesize 512

prompt ----------------------------------
prompt - Types d'objets des tablespaces -
prompt ----------------------------------

column count(*) heading 'Nbre d''objets'
column sum(bytes) heading 'Octets'

SELECT 
   tablespace_name TABLESPACE, 
   owner UTILISATEUR, 
   segment_type "TYPE SEGMENT", 
   count(*), 
   sum(bytes)
FROM 
   sys.dba_extents
GROUP BY 
   tablespace_name, owner, segment_type
ORDER BY 
   tablespace_name, owner, segment_type;
