1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
create table dvp_test ( a varchar2(10));
insert into dvp_test values ( 'DVP') ;
commit ;
select object_name , a.object_id , locked_mode
from dba_objects a, V$LOCKED_OBJECT b
where a.object_id =b.object_id ;
select * from dvp_test for update ;
select object_name , a.object_id , locked_mode
from dba_objects a, V$LOCKED_OBJECT b
where a.object_id =b.object_id ;
SQL> create table dvp_test ( a varchar2(10));
Table créée.
SQL> insert into dvp_test values ( 'DVP') ;
1 ligne créée.
SQL> commit ;
Validation effectuée.
SQL> select object_name , a.object_id , locked_mode
2 from dba_objects a, V$LOCKED_OBJECT b
3 where a.object_id =b.object_id ;
aucune ligne sélectionnée
SQL> select * from dvp_test for update ;
A
----------
DVP
SQL> select object_name , a.object_id , locked_mode
2 from dba_objects a, V$LOCKED_OBJECT b
3 where a.object_id =b.object_id ;
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_ID LOCKED_MODE
---------- -----------
DVP_TEST
4609728 3
SQL> commit ;
Validation effectuée.
SQL> select object_name , a.object_id , locked_mode
2 from dba_objects a, V$LOCKED_OBJECT b
3 where a.object_id =b.object_id ;
aucune ligne sélectionnée |
