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');
-----------------------------------------------------------------
'개발 및 관리 > Oracle 9i, 10g, 11g, 12c, 19c' 카테고리의 다른 글
| Recovery Case Analysis by 방형욱 선생님 (0) | 2012.12.03 |
|---|---|
| (VMWARE 인터넷 문제) VMWARE에 리눅스 INSTALL 후 인터넷 문제 (0) | 2012.12.01 |
| EM(Enterprise Manager) management, iSQP*PLus management (0) | 2012.11.22 |
| Hidden Parameter 보기 (0) | 2012.11.22 |
| Undo와 Redo (0) | 2012.11.20 |
