|
('SID')
--------------
27
--执行move操作
--session 1
zx@ORA12C>alter table t move online tablespace examples;
Table altered.
Elapsed: 00:00:34.73
--session 2
zx@ORA12C>delete from t where object_name='USER_TABLES';
256 rows deleted.
Elapsed: 00:00:00.97
zx@ORA12C>rollback;
Rollback complete.
--session 3
sys@ORA12C>select /*+ rule */ sid,lmode,request,type,block from v$lock where sid in (23,27);
SID LMODE REQUEST TY BLOCK
---------- ---------- ---------- -- ----------
27 3 0 TM 0
27 4 0 AE 0
27 6 0 TX 0
23 4 0 AE 0
23 6 0 OD 0
23 3 0 DL 0
23 3 0 DL 0
23 6 0 TS 0
23 6 0 TM 0
23 4 0 TM 0
23 6 0 TM 0
23 3 0 TM 0
23 6 0 TX 0
23 6 0 TX 0
23 3 0 TM 0
23 3 0 TM 0
16 rows selected.
从上面的操作可以看出12.2的move操作没有阻塞delete操作。
参考：http://docs.oracle.com/database/122/NEWFT/new-features.htm#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D
|