关于alter table xxx enable table lock

xGss2000

原帖由 Yong Huang 于 2010-1-27 02:59 发表
How are you so sure "不可对我这张表持有锁的"? I bet you can find its transaction in v$transaction.

Why not try to reproduce this with SQL trace turned on for that Weblogic session so we know what SQL it runs along the way? There must be some DML in the middle of it.

Yong Huang

我是第三方合作人员，没有dba权限，更不知道sys用户的密码。没办法做其他session的sql_trace。
刚刚做了自己的'alter table test_d enable table lock'进程的sql_trace,却发现没有读trace文件的权限......

2jliu

原帖由 xGss2000 于 2010-1-27 15:01 发表


我是第三方合作人员，没有dba权限，更不知道sys用户的密码。没办法做其他session的sql_trace。
刚刚做了自己的'alter table test_d enable table lock'进程的sql_trace,却发现没有读trace文件的权限......

算幸运,生产系统没有异常

sky_heaven

#[/oracle] sqlplus acct/acct

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Mar 9 13:42:01 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> create table test_d as select * from all_tables;

Table created.

SQL> alter table test_d disable table lock;

Table altered.

SQL> drop table test_d;
drop table test_d
           *
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for TEST_D


SQL> alter table test_d enable table lock;

Table altered.

SQL> drop table test_d;

Table dropped.

SQL> select * from v$version where rownum = 1;

BANNER
--------------------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

试了下 9.2.0.4 Linux 正常