<div>
<div class="content wysiwyg-content">
Anyone used the result_cache init.ora parameter for OLTP Oracle 11.2.0.4 ?<br />
Can this be used in production without any harm ? if yes, What should be the value be chosen for result_cache_mode between manual or force?<br />
I am mainly looking for these 3 parameters:-<br />
<br />
result_cache_max_size &nbsp; &nbsp; :- What percentage of SGA should be used? I have 64gb of sga_max_size<br />
result_cache_max_result :- What value be used for a heavy OLTP database?<br />
result_cache_mode :- manual or force
</div>
</div>


Anyone used the result_cache init.ora parameter for OLTP Oracle 11.2.0.4 ?
Can this be used in production without any harm ? if yes, What should be the value be chosen for result_cache_mode between manual or force?
I am mainly looking for these 3 parameters:-

result_cache_max_size     :- What percentage of SGA should be used? I have 64gb of sga_max_size
result_cache_max_result :- What value be used for a heavy OLTP database?
result_cache_mode :- manual or force

Is result cache init.ora parameter can be benefited  for an Oracle OLTP database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.