doc

    Name:   poolfail.sql

    Author: Mark Gurry

    This script informs you if the larger objects have failed to obtain
    space in the part of the shared pool reserved for larger objects.

#

column next_line format a60 newline
ttitle ' Shared Pool Reserved Size Recommendation'
select 'You may need to increase the SHARED_POOL_RESERVED_SIZE' next_line, '
        Request Failures = '||request_failures
	from v$shared_pool_reserved
 where request_failures > 0
	and 0 != ( select to_number(value) 
				from v$parameter 
				where name = 'shared_pool_reserved_size' );