-- name       : stats.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Show the system statistics
-- limitation : needs access to v$sysstat
--
-- useage     : SQL> @stats

set pages 50
set feed off
set echo off
set verify off
set linesize 200

spool stats.lis

col name head "Name" for a60
col value head "Value" for 999,999,999,999

ttitle "System Statistics"

select 	value value,
	name name
from 	v$sysstat
/

spool off

set pages 24
set feed on
set echo on
set verify on
set lines 80