simulate row cache lock on dc_object_ids
TEST @ racdb1 >select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
create table t as select * from dba_objects where rownum<10;
session 1:
select * from tab$ where obj#=(select obj# from obj$ where name='T') for update;
session 2:
drop table t;
purge user_recyclebin;
session 3:
purge user_recyclebin;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/37279/viewspace-762150/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
