Ñ§Ï°Íø¿¼ÊÔѧϰ×ÊÁÏ

Gzu521.com

Oracle9iµ½10g,¿ÕÏеȴýʼþµÄ±ä»¯(1)

ORACLE/CIWÈÏÖ¤   µã»÷£º´Î   ·¢²¼Ê±¼ä£º2006-10-31   ¡¾×ÖÌ壺´ó ÖРС¡¿   À´Ô´£ºGzu521.com
Gzu521.comÎÒµÄÑ§Ï°Íø
 

´ÓstatspackµÄ´´½¨½Å±¾ÖÐ,ÎÒÃÇ¿ÉÒÔ¿´µ½´ÓOracle9iµ½oracle10g,¿ÕÏеȴýʼþµÄ¸Ä±ä.

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

ÔðÈα༭£ºgzu521

ITÈÏÖ¤·ÖÀà
¼ÆËã»úÈí¼þˮƽ¿¼ÊÔ
È«¹ú¼ÆËã»úµÈ¼¶¿¼ÊÔ
˼¿ÆÈÏÖ¤
΢ÈíÈÏÖ¤
ORACLE/CIWÈÏÖ¤
LinuxÈÏÖ¤
JAVAÈÏÖ¤
ÆäËüÈÏÖ¤
·ÖÀàÍÆ¼öÐÅÏ¢
¸ü¶à...
´óÀà×îÐÂÎÄÕÂ
¸ü¶à...