Oracle Study之--Oracle等待事件（6）
12:54:01 SYS@ prod>conn scott/tigerConnected.
12:54:05 SCOTT@ prod>select * from tab;
TNAME TABTYPECLUSTERID
------------------------------ ------- ----------
BONUS TABLE
DEPT TABLE
DEPT1 TABLE
EMP TABLE
SALGRADE TABLE
T1 TABLE
6 rows selected.
12:54:09 SCOTT@ prod>grant all on dept1 to tom;
Grant succeeded.
Elapsed: 00:00:00.37
12:54:23 SCOTT@ prod>update dept1 set dname='beijing' where deptno=10;
2 rows updated.
Elapsed: 00:00:00.04
12:54:41 SCOTT@ prod>rollback;
Rollback complete.
Elapsed: 00:00:00.03
12:55:22 SCOTT@ prod>update dept1 set dname='NetWork' where deptno=10;
2 rows updated.
Elapsed: 00:00:00.02
12:54:51 SYS@ prod>conn tom/tom
Connected.
12:54:56 TOM@ prod>update scott.dept1 set loc='hongkong' where deptno=10;
12:59:18 SYS@ prod>col event for a50
12:59:26 SYS@ prod>r
1SELECT event,CHR (TO_CHAR (BITAND (p1, -16777216)) / 16777215)
2 || CHR (TO_CHAR (BITAND (p1, 16711680)) / 65535)
3 "Lock",
4 TO_CHAR (BITAND (p1, 65535)) "Mode"
5 FROM v$session_wait
6*WHERE event like 'enq%'
EVENT Lock Mode
-------------------------------------------------- ---- ----------------------------------
enq: TX - row lock contention TX 6
Elapsed: 00:00:00.01
13:22:48 SYS@ prod>select a.ORACLE_USERNAME,a.SESSION_ID,b.TYPE,b.LMODE,b.REQUEST,b.block,o.object_name from v$locked_object a,v$lock b,dba_objects o
2*where a.session_id=b.sid and a.object_id=o.object_id
ORACLE_USERNAME SESSION_ID TY LMODE REQUEST BLOCK OBJECT_NAM
------------------------------ ---------- -- ---------- ---------- ---------- ----------
SCOTT 42 TX 6 0 1 DEPT1
TOM 38 TM 3 0 0 DEPT1
SCOTT 42 TM 3 0 0 DEPT1
TOM 38 TX 0 6 0 DEPT1
TOM 38 AE 4 0 0 DEPT1
SCOTT 42 AE 4 0 0 DEPT1
6 rows selected.
页:
[1]