Oracle 10g对DBWR的SCAN间隔进行了调整

王朝oracle·作者佚名  2006-11-24
窄屏简体版  字體: |||超大  

了避免DBWR不必要的唤醒及过于活跃,从Oracle10g开始,Oracle对DBWR的SCAN间隔进行了调整.

在内部由一个隐含参数:_dbwr_scan_interval 控制.

Oracle9i中这个参数缺省值为10 s:

SQL> select * from v$version 2 /

BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionPL/SQL Release 9.2.0.4.0 - ProductionCORE 9.2.0.3.0 ProductionTNS for Solaris: Version 9.2.0.4.0 - ProductionNLSRTL Version 9.2.0.4.0 - Production

SQL> col ksppinm for a20SQL> col ksppdesc for a40SQL> col ksppstvl for a10SQL> select 2 ksppinm,ksppdesc,ksppstvl 3 from 4 sys.x$ksppi x, 5 sys.x$ksppcv y 6 where 7 x.inst_id = userenv('Instance') and 8 y.inst_id = userenv('Instance') and 9 x.indx = y.indx and 10 x.ksppinm like '%_dbwr_scan%' 11 /

KSPPINM KSPPDESC KSPPSTVL-------------------- ---------------------------------------- ----------_dbwr_scan_interval dbwriter scan interval 10

从Oracle10g开始,此缺省值被调这个为300 s:

SQL> select * from v$version 2 /

BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64biPL/SQL Release 10.1.0.3.0 - ProductionCORE 10.1.0.3.0 ProductionTNS for Solaris: Version 10.1.0.3.0 - ProductionNLSRTL Version 10.1.0.3.0 - Production

SQL> col ksppinm for a20SQL> col ksppdesc for a40SQL> col ksppstvl for a10SQL> select 2 ksppinm,ksppdesc,ksppstvl 3 from 4 sys.x$ksppi x, 5 sys.x$ksppcv y 6 where 7 x.inst_id = userenv('Instance') and 8 y.inst_id = userenv('Instance') and 9 x.indx = y.indx and 10 x.ksppinm like '%_dbwr_scan%' 11 /

KSPPINM KSPPDESC KSPPSTVL-------------------- ---------------------------------------- ----------_dbwr_scan_interval dbwriter scan interval 300

在Oracle10gR2中,这个参数未作进一步调整,缺省值仍然为300:

SQL> select * from v$version 2 /

BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.2.0.1.0 ProductionTNS for Linux: Version 10.2.0.1.0 - ProductionNLSRTL Version 10.2.0.1.0 - Production

SQL> col ksppinm for a20SQL> col ksppdesc for a40SQL> col ksppstvl for a10SQL> select 2 ksppinm,ksppdesc,ksppstvl 3 from 4 sys.x$ksppi x, 5 sys.x$ksppcv y 6 where 7 x.inst_id = userenv('Instance') and 8 y.inst_id = userenv('Instance') and 9 x.indx = y.indx and 10 x.ksppinm like '%_dbwr_scan%' 11 /

KSPPINM KSPPDESC KSPPSTVL-------------------- ---------------------------------------- ----------_dbwr_scan_interval dbwriter scan interval 300

以上内容,仅供参考.

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航