/**********************************************************************
 * File:	spparms.sql
 * Type:	SQL*Plus script
 * Author:	Tim Gorman (Evergreen Database Technologies, Inc.)
 * Date:	30-Apr-01
 *
 * Description:
 *	Script to update the STATS$STATSPACK_PARAMETER table in
 *	STATSPACK v8.1.7 to reflect more responsible statistics
 *	collection in busy systems.  Based on recommended values
 *	described in MetaLink note describing the use of STATSPACK in
 *	Oracle Apps environments...
 *
 * Modifications:
 *	TGorman 15may02	Modified to use STATSPACK procedure instead of
 *			updating table directly...
 *********************************************************************/
whenever oserror exit failure rollback
whenever sqlerror exit failure rollback
set echo on feedback on timing on pagesize 100

spool spparms

select  *
from    stats$statspack_parameter;

exec statspack.modify_statspack_parameter( -
        i_snap_level => 7, -
        i_executions_th => 1000, -
        i_parse_calls_th => 1000, -
        i_disk_reads_th => 10000, -
        i_buffer_gets_th => 100000, -
        i_sharable_mem_th => 1048576, -
        i_version_count_th => 20, -
	i_seg_itl_waits_th => 1)

select  *
from    stats$statspack_parameter;

spool off