/* ------------------------------------------------------------------------- */ (2?ldS!=L 6P7{}j [ 本 资 料 来 源 于 贵 州 学 习 网 IT认证ORACLE/CIW认证 http://Www.gzU521.com ] (2?ldS!=L 6P7{}j

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;

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