| 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';
No comments:
Post a Comment