SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 256

PROMPT --------------------------------
PROMPT - Rollback Segments de la base -
PROMPT --------------------------------

column UTILISATEUR format a20

SELECT
	r.segment_name	SEGMENT,
	r.owner		UTILISATEUR,	
	r.tablespace_name	TABLESPACE,
	r.status		STATUT,
	round(r.initial_extent/1024/1024) "Init (Mo)",
	round(r.next_extent/1024/1024) "Next (Mo)",
	s.extents "NBR EXTENTS",
	ROUND(s.rssize/1024/1024)	"Taile (Mo)",
	s.xacts			active_trans
FROM
	dba_rollback_segs r,
	v$rollname	  n,
	v$rollstat	  s
WHERE
	r.segment_name = n.name
AND
	n.usn = s.usn;
