RX, TX LOCK 관련 예제

export ORACLE_SID=ardb

-----------------------------------------------------------------
select * from v$resource where type in ('TM', 'TX');
select * from v$lock where type in ('TM', 'TX');
-----------------------------------------------------------------

update t1
set sal = sal+1000
where rownum = 1;

-----------------------------------------------------------------
select * from v$resource where type in ('TM', 'TX');
select * from v$lock where type in ('TM', 'TX');
-----------------------------------------------------------------

update t1
set sal = 2000
where empno=7788;

-----------------------------------------------------------------
select * from v$resource where type in ('TM', 'TX');
select * from v$lock where type in ('TM', 'TX');
-----------------------------------------------------------------

update t1
set sal = sal+1000
where rownum = 1;

-----------------------------------------------------------------
select * from v$resource where type in ('TM', 'TX');
select * from v$lock where type in ('TM', 'TX');
-----------------------------------------------------------------

alter table t1 drop(sal);

-----------------------------------------------------------------
select * from v$resource where type in ('TM', 'TX');
select * from v$lock where type in ('TM', 'TX');
-----------------------------------------------------------------