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

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

在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: 0delete 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. /* ------------------------------------------------------------------------- */