select tablespace_name, sum(sizes) razmer, sum(occupied) zanyato,
       sum(free) svobodno, round(sum(persent)/count(*),2) procent
  from (SELECT t.tablespace_name, t.status,
               ROUND((MAX(d.bytes)/1024/1024)-(SUM(decode(f.bytes,NULL,0,f.bytes))/1024/1024),2)+ROUND(SUM(decode(f.bytes,NULL,0,f.bytes))/1024/1024,2) as sizes,
               ROUND((MAX(d.bytes)/1024/1024)-(SUM(decode(f.bytes,NULL,0,f.bytes))/1024/1024),2) as occupied,
               ROUND(SUM(decode(f.bytes,NULL,0,f.bytes))/1024/1024,2) as free,
               ROUND((ROUND((MAX(d.bytes)/1024/1024)-(SUM(decode(f.bytes,NULL,0,f.bytes))/1024/1024),2) /
                     (ROUND((MAX(d.bytes)/1024/1024)-(SUM(decode(f.bytes,NULL,0,f.bytes))/1024/1024),2) +
                      ROUND(SUM(decode(f.bytes,NULL,0,f.bytes))/1024/1024,2) )
                     )*100,3) as persent,
               t.initial_extent, t.next_extent, t.min_extents,
               t.max_extents, t.pct_increase, SUBSTR(d.file_name,1,80)
          FROM DBA_FREE_SPACE f , DBA_DATA_FILES d , DBA_TABLESPACES t
          WHERE t.tablespace_name=d.tablespace_name 
                AND f.tablespace_name(+)=d.tablespace_name
                AND f.file_id(+) = d.file_id
                and t.tablespace_name='RLBK'
        GROUP BY t.tablespace_name, d.file_name, t.initial_extent, t.next_extent, t.min_extents, t.max_extents, t.pct_increase, t.status)
group by tablespace_name
order by procent desc, razmer

#rollback_segments = (RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8, RBS9, RBS10, RBS11, RBS12, RBS13, RBS14, RBS15, RBS16, RBS17, RBS18, RBS19, RBS20, RBS21, RBS22, RBS23, RBS24)

select name, type, value
  from v$parameter 
  where name like '%rollback%' 
        or name like '%undo%'

alter system set rollback_segments=(RBS01, RBS02, RBS03, RBS04, RBS05, RBS06, RBS07, RBS08);