RESULT_CACHE_MAX_RESULT

Property	Description
Parameter type	Integer
Default value	5 percent
Modifiable	ALTER SYSTEM
Range of values	0 to 100
Basic	No

RESULT_CACHE_MAX_RESULT specifies the percentage of RESULT_CACHE_MAX_SIZE that any single result can use.

Note:

1. The parameter was introduced in 11g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = 'RESULT_CACHE_MAX_RESULT';

Oracle initializatoin parameters