ITPub博客

首页 > Linux操作系统 > Linux操作系统 > simulate row cache lock on dc_object_ids

simulate row cache lock on dc_object_ids

原创 Linux操作系统 作者:warmbreeze 时间:2013-05-28 08:44:31 0 删除 编辑
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
 
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博客 ” ,链接:http://blog.itpub.net/37279/viewspace-762150/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-15

  • 博文量
    45
  • 访问量
    42546