/* ************************************************** */
/*                                                    */
/* Script: Display information about rollback segment */          */
/*                                                    */
/* name:    @c:\oracle\sql\v$rollbk.sql               */
/* date:    24-AUG-95                                 */
/* creator: Rick Kupcunas                             */
/*                                                    */
/* ************************************************** */

set pagesize 65;
set linesize 80;

select 	substr(name, 1,7) 		"NAME",
	substr(to_char(waits),1,5) 	"WAITS", 
	substr(to_char(gets),1, 7)    	"GETS",
	(waits/gets)*100 Ratio,
	hwmsize,
	optsize,
	substr(to_char(shrinks),1,7)	"SHRINKS",
	substr(to_char(wraps),1,5)	"WRAPS",
	aveactive
  from v$rollstat  A,
	v$rollname B
  where A.usn = B.usn
order by 1 asc, 2 asc;

commit;

