select 'You may need to increase the SHARED_POOL_RESERVED_SIZE' Description,
       'Request Failures = '||REQUEST_FAILURES  Logic
from 	v$shared_pool_reserved
where 	REQUEST_FAILURES > 0
and 	0 != (
	select 	to_number(VALUE) 
        from 	v$parameter 
        where 	NAME = 'shared_pool_reserved_size')
union
select 'You may be able to decrease the SHARED_POOL_RESERVED_SIZE' Description,
       'Request Failures = '||REQUEST_FAILURES Logic
from 	v$shared_pool_reserved
where 	REQUEST_FAILURES < 5
and 	0 != ( 
	select 	to_number(VALUE) 
	from 	v$parameter 
	where 	NAME = 'shared_pool_reserved_size')


Connect time(ms): 468

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 110

DESCRIPTION|LOGIC
You may be able to decrease the SHARED_POOL_RESERVED_SIZE|Request Failures = 0

