Oracle9i到10g,空闲等待事件的变化(1)

文章作者 100test 发表时间 2007:03:14 13:47:33
来源 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.