Shulou(Shulou.com)06/01 Report--

SELECT x.ksppinm name,y.ksppstvl value,y.ksppstdf isdefault,decode (bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismod,decode (bitand(y.ksppstvf,2),2,'TRUE','FALSE') isadjFROMsys.x$ksppi x, sys.x$ksppcv yWHEREx.inst_id = userenv ('Instance ') ANDy.inst_id = userenv ('Instance') ANDx.indx = y.indx--and x.ksppinm ='_external_scn_rejection_threshold_hours'order BY translate(x.ksppinm, '_','); Modify Implied Parameter Method:

Here is an example of modifying DRM (buggy, RAC instance crash) implicit parameters. Different implicit parameters can be modified differently. For details, please refer to the documentation.

Method 1: SQL> alter system set "_gc_policy_time"=0 scope=spfile sid ='*';System altered.SQL> alter system set "_gc_undo_affinity"=false scope=spfile sid ='*';System altered.

After the change is completed, it needs to be restarted to take effect. Check

Method 2 (cannot restart)

If you can't restart the instance temporarily, you can disable DRM with the command "In fact":(The following two parameters can be adjusted dynamically)

alter system set "_gc_affinity_limit"=10000000;alter system set "_gc_affinity_minimum"=10000000;

summary

The above is the ORACLE hidden parameters introduced by Xiaobian to you to view and modify the method, I hope to help you, if you have any questions please give me a message, Xiaobian will reply to you in time. Thank you very much for your support!

If you think this article is helpful to you, welcome to reprint, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.