Oracle10gR2自动检查点调整的新特性

文章作者 100test 发表时间 2007:03:14 13:37:18
来源 100Test.Com百考试题网


从Statspack的创建脚本中,我们可以看到从Oracle9i到Oracle10g,空闲等待事件的改变.

  空闲等待事件在Statspack中,记录在系统表STATS$IDLE_EVENT中.检查其创建脚本我们可以找到这些变化.这个脚本位于  $ORACLE_HOME/rdbms/admin/spctab.sql

  在Oracle9iR2中,空闲等待有:

/* ------------------------------------------------------------------------- */

create table STATS$IDLE_EVENT
(event varchar2(64) not null
,constraint STATS$IDLE_EVENT_PK primary key (event)
using index tablespace &.&.tablespace_name
storage (initial 100k next 100k pctincrease 0)
) tablespace &.&.tablespace_name
storage (initial 100k next 100k pctincrease 0) pctfree 5 pctused 40.

insert into STATS$IDLE_EVENT (event) values (smon timer).
insert into STATS$IDLE_EVENT (event) values (pmon timer).
insert into STATS$IDLE_EVENT (event) values (rdbms ipc message).
insert into STATS$IDLE_EVENT (event) values (Null event).
insert into STATS$IDLE_EVENT (event) values (parallel query dequeue).
insert into STATS$IDLE_EVENT (event) values (pipe get).
insert into STATS$IDLE_EVENT (event) values (client message).
insert into STATS$IDLE_EVENT (event) values (SQL*Net message to client).
insert into STATS$IDLE_EVENT (event) values (SQL*Net message from client).
insert into STATS$IDLE_EVENT (event) values (SQL*Net more data from client).
insert into STATS$IDLE_EVENT (event) values (dispatcher timer).
insert into STATS$IDLE_EVENT (event) values (virtual circuit status).
insert into STATS$IDLE_EVENT (event) values (lock manager wait for remote message).
insert into STATS$IDLE_EVENT (event) values (PX Idle Wait).
insert into STATS$IDLE_EVENT (event) values (PX Deq: Execution Msg).
insert into STATS$IDLE_EVENT (event) values (PX Deq: Table Q Normal).
insert into STATS$IDLE_EVENT (event) values (wakeup time manager).
insert into STATS$IDLE_EVENT (event) values (slave wait).
insert into STATS$IDLE_EVENT (event) values (i/o slave wait).
insert into STATS$IDLE_EVENT (event) values (jobq slave wait).
insert into STATS$IDLE_EVENT (event) values (null event).
insert into STATS$IDLE_EVENT (event) values (gcs remote message).
insert into STATS$IDLE_EVENT (event) values (gcs for action).
insert into STATS$IDLE_EVENT (event) values (ges remote message).
insert into STATS$IDLE_EVENT (event) values (queue messages).
commit.

create public synonym STATS$IDLE_EVENT for STATS$IDLE_EVENT.

/* ------------------------------------------------------------------------- */

  在Oracle10gR2中,这个数字大大增加:

/* ------------------------------------------------------------------------- */

create table STATS$IDLE_EVENT
(event varchar2(64) not null
,constraint STATS$IDLE_EVENT_PK primary key (event)
using index tablespace &.&.tablespace_name
storage (initial 100k next 100k pctincrease 0)
) tablespace &.&.tablespace_name
storage (initial 100k next 100k pctincrease 0) pctfree 5 pctused 40.

insert into STATS$IDLE_EVENT (event) values (smon timer).
insert into STATS$IDLE_EVENT (event) values (pmon timer).
insert into STATS$IDLE_EVENT (event) values (rdbms ipc message).
insert into STATS$IDLE_EVENT (event) values (Null event).
insert into STATS$IDLE_EVENT (event) values (parallel query dequeue).
insert into STATS$IDLE_EVENT (event) values (pipe get).
insert into STATS$IDLE_EVENT (event) values (client message).
insert into STATS$IDLE_EVENT (event) values (SQL*Net message to client).
insert into STATS$IDLE_EVENT (event) values (SQL*Net message from client).
insert into STATS$IDLE_EVENT (event) values (SQL*Net more data from client).
insert into STATS$IDLE_EVENT (event) values (dispatcher timer).
insert into STATS$IDLE_EVENT (event) values (virtual circuit status).


相关文章


SQLServer2005数据库升级技巧(图)(二)
Oracle9i到10g,空闲等待事件的变化
新的Oracle企业软件“探秘”
Oracle发布Berkeley_DB_Java
Oracle10gR2自动检查点调整的新特性
用Oracle并行查询发挥多CPU的威力(2)
当Spring遇到了Oracle,该怎么办
发财季报告甲骨文公司未来一片光明
在Windows上命令行手工启停Oracle
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛