Oracle10gR2有什么新特性?
从Statspack的创建脚本中,我们可以看到从Oracle9i到Oracle10g,空闲等待事件的改变。
空闲等待事件在Statspack中,记录在系统表STATS$IDLE_EVENT中。 检查其创建脚本我们可以找到这些变化。这个脚本位于
$ORACLE_HOME/rdbms/admin/spctab。 sql
在Oracle9iR2中,空闲等待有:/* ------------------------------------------------------------------------- */create table
STATS$IDLE_EVENT(event
var...全部
从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;/* ------------------------------------------------------------------------- */
在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');。收起