/* ************************************************ */
/*                                                  */
/* Script: Display statistics on the activity of    */
/*         the sorts                                */
/*                                                  */
/* name:    @c:\oracle\sql\v$sysstat.sql            */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select name, value
from v$sysstat
order by 1 asc;

Prompt:  verify the SORT values; do we have a lot of writes to 
Prompt:  the temporary tablespaces.....

commit;

