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')

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