上个星期直接DROP也是一样的,
而且删除这个表空间里的表对象的时候也非常的慢
select * from v$session_wait;
1 7 3400 latch free address 1.38350580556225E19 C00000001448E428 number 66 0000000000000042 tries 0 00 -2 2 WAITED UNKNOWN TIME
2 32 644 latch free address 1.38350580556206E19 C0000000142B6428 number 66 0000000000000042 tries 0 00 -2 61 WAITED UNKNOWN TIME
3 1 967 pmon timer duration 300 000000000000012C 0 00 0 00 0 11157 WAITING
4 2 21310 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 0 1975 WAITING
5 3 61784 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 0 0 WAITING
6 8 1 rdbms ipc message timeout 6000 0000000000001770 0 00 0 00 0 12 WAITING
7 34 1 rdbms ipc message timeout 6000 0000000000001770 0 00 0 00 0 12 WAITING
8 27 1 rdbms ipc message timeout 6000 0000000000001770 0 00 0 00 0 12 WAITING
9 6 9278 rdbms ipc message timeout 180000 000000000002BF20 0 00 0 00 0 10897 WAITING
10 19 1 rdbms ipc message timeout 6000 0000000000001770 0 00 0 00 0 12 WAITING
11 4 4697 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 0 0 WAITING
12 25 70 enqueue name|mode 1414791174 0000000054540006 id1 10 000000000000000A id2 0 00 0 123 WAITING
13 5 23501 smon timer sleep time 300 000000000000012C failed 0 00 0 00 0 6239 WAITING
14 9 161 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 15488 WAITING
15 21 250 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 0 WAITING
16 23 1454 SQL*Net message from client driver id 1650815232 0000000062657100 #bytes 1 0000000000000001 0 00 0 4026 WAITING
17 28 88 SQL*Net message from client driver id 1650815232 0000000062657100 #bytes 1 0000000000000001 0 00 0 205 WAITING
18 31 86 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 171 WAITING
19 37 983 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 2301 WAITING
20 39 64 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 6808 WAITING
21 40 102 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 15406 WAITING
22 38 6 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 15541 WAITING
23 35 237 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 -2 0 WAITED UNKNOWN TIME
24 29 512 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 288 WAITING
25 26 24 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 58 WAITING
26 24 329 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 3 WAITING
27 11 6201 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 2320 WAITING
28 18 116 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 0 7007156 WAITING