´ÓstatspackµÄ´´½¨½Å±¾ÖÐ,ÎÒÃÇ¿ÉÒÔ¿´µ½´ÓOracle9iµ½oracle10g,¿ÕÏеȴýʼþµÄ¸Ä±ä.
¿ÕÏеȴýʼþÔÚstatspackÖÐ,¼Ç¼ÔÚϵͳ±ístats$idle_eventÖÐ.¼ì²éÆä´´½¨½Å±¾ÎÒÃÇ¿ÉÒÔÕÒµ½ÕâЩ±ä»¯.Õâ¸ö½Å±¾Î»ÓÚ$oracle_home/rdbms/admin/spctab.sql %)W
nMCi#o#F?j€ [ ±¾ ×Ê ÁÏ À´ Ô´ ÓÚ ¹ó ÖÝ Ñ§ ϰ Íø ITÈÏÖ¤ORACLE/CIWÈÏÖ¤ http://Www.gzU521.com ] %)W
nMCi#o#F?j€
ÔÚ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; |