WEB开发网
开发学院数据库Oracle Oracle9i到10g空闲等待事件的变化 阅读

Oracle9i到10g空闲等待事件的变化

 2007-09-02 12:39:30 来源:WEB开发网   
核心提示:从Statspack的创建脚本中,我们可以看到从Oracle9i到Oracle10g,空闲等待事件的改变. 空闲等待事件在Statspack中,记录在系统表STATS$IDLE_EVENT中.检查其创建脚本我们可以找到这些变化.这个脚本位于$ORACLE_HOME/rdbms/admin/spctab.sql 在Ora

从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;
/* ------------------------------ */

1 2  下一页

Tags:Oraclei 空闲 等待

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接