无他,仅仅是一个测试过程 [shared]

显示全部楼层 · 2008-2-13 12:43:03

[php]
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\>sqlplus cmssy/lion1@sphtest
SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 12月 27 15:28:39 2007
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.

连接到:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
YXYUP@yxyup> set autot traceonly
YXYUP@yxyup> delete audbill where length ( id )rollback;
回退已完成。
YXYUP@yxyup> create index idx_audbill_lengthid on audbill (length ( id )) tabl
espace indx;
索引已创建。
YXYUP@yxyup> delete audbill where length ( id )analyze table audbill compute statistics;
表已分析。
YXYUP@yxyup> delete audbill where length ( id )set timing on
YXYUP@yxyup> delete audbill where length ( id )drop index idx_audbill_lengthid;
索引已丢弃。
已用时间:00: 00: 00.05
YXYUP@yxyup> delete audbill where length ( id )
[/php]

千问 · 2008-2-13 12:43:03

真的无他了

千问 · 2008-2-13 12:43:03

做了那么多。写个总结啊

千问 · 2008-2-13 12:43:03

[php]
SQL> select event,total_waits,time_waited from V$system_event order by time_waited asc;
EVENT
TOTAL_WAITS TIME_WAITED
----------------------------------- ----------- -----------
latch free
6 0
async disk IO
127 0
reliable message
5 0
refresh controlfile command
1 0
db file parallel write
2766 0
direct path write
60 0
library cache load lock
2 0
SQL*Net more data to client
37 0
SQL*Net more data from client
80 0
SQL*Net message to client
3313 0
instance state change
2 0
EVENT
TOTAL_WAITS TIME_WAITED
----------------------------------- ----------- -----------
direct path read
73 0
db file single write
3 0
buffer busy waits
5 0
SQL*Net break/reset to client
231 1
LGWR wait for redo copy
755 3
log file sync
8 3
rdbms ipc reply
35 9
enqueue
47
11
log file switch completion
3
11
log file single write
72
19
db file scattered read
1085
23
EVENT
TOTAL_WAITS TIME_WAITED
----------------------------------- ----------- -----------
control file single write
20
54
db file sequential read
1854
92
process startup
11 108
log file sequential read
265 190
control file sequential read
53179 224
control file heartbeat
1 401
free buffer waits
9 532
switch logfile command
191020
EVENT
TOTAL_WAITS TIME_WAITED
----------------------------------- ----------- -----------
wakeup time manager
748422382591
smon timer
77922417943
pmon timer
8312223211211
rdbms ipc message
306385 173356070
37 rows selected.
[/php]

千问 · 2008-2-13 12:43:03

我来给无他总结
9i建完索引之后需要再分析一下，10g建完就能用了