网站首页
JSP空间
动态资讯
开源项目
技术文档
资源下载
J2EE资源
客户论坛
在线支付
 
  技术文档>>数据库技术>>Oracle技术>>Oracle开发>查看文档  
  解析:Oracle9i到10g空闲等待事件的变化     
  文章作者:未知  文章来源:未知  
  查看:162次  录入:管理员--2007-09-01  
 

从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');
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');
insert into STATS$IDLE_EVENT (event) 
values ('wait for unread message on broadcast channel');
insert into STATS$IDLE_EVENT (event) 
values ('PX Deq Credit: send blkd');
insert into STATS$IDLE_EVENT (event) 
values ('PX Deq: Execute Reply');
insert into STATS$IDLE_EVENT (event) 
values ('PX Deq: Signal ACK');
insert into STATS$IDLE_EVENT (event) 
values ('PX Deque wait');
insert into STATS$IDLE_EVENT (event) 
values ('PX Deq Credit: need buffer');
insert into STATS$IDLE_EVENT (event) 
values ('STREAMS apply coord waiting for slave message'); 
insert into STATS$IDLE_EVENT (event) 
values ('STREAMS apply slave waiting for coord message'); 
insert into STATS$IDLE_EVENT (event) 
values ('Queue Monitor Wait'); 
insert into STATS$IDLE_EVENT (event) 
values ('Queue Monitor Slave Wait'); 
insert into STATS$IDLE_EVENT (event) 
values ('wakeup event for builder'); 
insert into STATS$IDLE_EVENT (event) 
values ('wakeup event for preparer'); 
insert into STATS$IDLE_EVENT (event) 
values ('wakeup event for reader'); 
insert into STATS$IDLE_EVENT (event) 
values ('wait for activate message'); 
insert into STATS$IDLE_EVENT (event) 
values ('PX Deq: Par Recov Execute');
insert into STATS$IDLE_EVENT (event) 
values ('PX Deq: Table Q Sample');
insert into STATS$IDLE_EVENT (event) 
values ('STREAMS apply slave idle wait');
insert into STATS$IDLE_EVENT (event) 
values ('STREAMS capture process filter callback wait for ruleset');
insert into STATS$IDLE_EVENT (event) 
values ('STREAMS fetch slave waiting for txns');
insert into STATS$IDLE_EVENT (event) 
values ('STREAMS waiting for subscribers to catch up');
insert into STATS$IDLE_EVENT (event) 
values ('Queue Monitor Shutdown Wait');
insert into STATS$IDLE_EVENT (event) 
values ('AQ Proxy Cleanup Wait');
insert into STATS$IDLE_EVENT (event) 
values ('knlqdeq');
insert into STATS$IDLE_EVENT (event) 
values ('class slave wait');
insert into STATS$IDLE_EVENT (event) 
values ('master wait');
insert into STATS$IDLE_EVENT (event) 
values ('DIAG idle wait');
insert into STATS$IDLE_EVENT (event) 
values ('ASM background timer');
insert into STATS$IDLE_EVENT (event) 
values ('KSV master wait');
insert into STATS$IDLE_EVENT (event) 
values ('EMON idle wait');
insert into STATS$IDLE_EVENT (event) 
values ('Streams AQ: RAC qmn coordinator idle wait');
insert into STATS$IDLE_EVENT (event) 
values ('Streams AQ: qmn coordinator idle wait');
insert into STATS$IDLE_EVENT (event) 
values ('Streams AQ: qmn slave idle wait');
insert into STATS$IDLE_EVENT (event) 
values ('Streams AQ: waiting for time management or cleanup tasks');
insert into STATS$IDLE_EVENT (event) 
values ('Streams AQ: waiting for messages in the queue');
insert into STATS$IDLE_EVENT (event) 
values ('Streams fetch slave: waiting for txns');
insert into STATS$IDLE_EVENT (event) 
values ('Streams AQ: deallocate messages from Streams Pool');
insert into STATS$IDLE_EVENT (event) 
values ('Streams AQ: delete acknowledged messages');
insert into STATS$IDLE_EVENT (event) 
values ('LNS ASYNC archive log');
insert into STATS$IDLE_EVENT (event) 
values ('LNS ASYNC dest activation');
insert into STATS$IDLE_EVENT (event) 
values ('LNS ASYNC end of log');
insert into STATS$IDLE_EVENT (event) 
values ('LogMiner: client waiting for transaction');
insert into STATS$IDLE_EVENT (event) 
values ('LogMiner: slave waiting for activate message');
insert into STATS$IDLE_EVENT (event)
values ('LogMiner: wakeup event for builder');
insert into STATS$IDLE_EVENT (event) 
values ('LogMiner: wakeup event for preparer');
insert into STATS$IDLE_EVENT (event) 
values ('LogMiner: wakeup event for reader');

commit;

create public synonym  STATS$IDLE_EVENT   for STATS$IDLE_EVENT;

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

如果你注意到的话,很多等待事件在9i中属于空闲等待,但是未被列入,有的是为了向后兼容,有的则是因为Bug。

 
 
上一篇: 解析Oracle/Oracle Forms 的多用途代码    下一篇: 实例解析:用Oracle创建实例的参数需求
  相关文档
"oracle"闪回功能恢复偶然丢失的数据 (1) 02-27
oracle数据库各种启动方式的详细介绍 01-25
如何使用new_value将查询结果传递给变量 04-10
讲解oracle数据库提供的多种安全性措施 (1) 05-05
实例讲解如何使用oracle数据库to_date() 04-17
实例讲解表碎片的具体起因及解决的办法 (1) 02-25
实例讲解清除oracle10g rac crs的方法 02-27
用events 跟踪解决不能创建物化试图一例 06-17
教你在Oracle中实现SELECT TOP N的方法 06-03
排除cache影响手动强制刷新buffer cache 05-27
Oracle动态并行处理框架及其优越性 04-12
关于Oracle中并行处理技术原理深入分析 04-12
oralce定时执行存储过程任务的设置步骤 03-03
奥运选手博客晒心情 满"博"尽是分享与理解 08-12
用Oracle 10g列值掩码技术隐藏敏感数据 04-11
八个学习点帮助你全面认识Oracle数据库TableSpace 06-03
Oracle 数据库集中复制方法逐步精细 05-27
循序渐进讲解oracle数据库的hash join (1) 04-30
使用"oracle"解析函数快速检查序列间隙 02-02
调用存储过程时注意要使用output做修饰符 04-09
返回首页 | 关于我们 | J网章程 | JSP空间合租 | 客服中心 | 免责声明 | 常见问题 | 参观机房
本站主机空间代理至厦门市华众网络科技有限公司
《中华人民共和国增值电信业务经营许可证》
编号:闽B2-20050079
@2005-2008福建JSP技术网 版权所有 闽ICP备05000928号
厦门(总部):13616026886 福州:0591-87655121
邮箱:admin@fjjsp.com 站长QQ,点击这里给我发消息