doc

    Name:   resdecr.sql

    Author: Mark Gurry

    This script informs you if you may be able to reduce your 
    SHARED_POOL_RESERVED_SIZE.

#

select 'You may be able to decrease the SHARED_POOL_RESERVED_SIZE' next_line, 
       'Request Failures = '||request_failures
  from v$shared_pool_reserved
 where request_failures < 5
	and 0 != ( select to_number(value) 
				from v$parameter 
				where name = 'shared_pool_reserved_size' );