| locking in oracle [message #145566] |
Thu, 03 November 2005 18:25  |
satishleo@gmail.com
Messages: 2
Registered: November 2005
|
Junior Member |
|
|
Here I inserted a single row in USA table. I know It will acquire a TX
lock in LMODE 6 & TM lock on LMODE 3.
And it would acquire all the child tables in TM LMODE 2.
But I see a few tables acquired on TM LMODE 3, other than USA ?
Why are few child tables inn LMODE 2 & few other in LMODE 3.
I really appreciate all your help into this issue.
Thanks
Satish
SQL>insert into COUNTRY values ( 'USA','XXX','XXX','XXX');
SQL> select object_name,object_id from dba_objects where object_id=54808;
object_name object_id
----------- ---------
USA 54808
SQL> select * from v$lock where sid=797;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
-------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
76A65058 76A6516C 797 TX 327697 1053730 6 0 1053 0
76930D20 76930D38 797 TM 42183 0 3 0 1053 0
76930C7C 76930C94 797 TM 54595 0 3 0 1053 0
76930BE8 76930C00 797 TM 94880 0 3 0 1053 0
76930B54 76930B6C 797 TM 87295 0 2 0 1053 0
76930AC0 76930AD8 797 TM 86821 0 2 0 1053 0
76930A2C 76930A44 797 TM 82679 0 2 0 1053 0
76930998 769309B0 797 TM 82662 0 2 0 1053 0
76930904 7693091C 797 TM 81118 0 2 0 1053 0
76930870 76930888 797 TM 66195 0 2 0 1053 0
769307DC 769307F4 797 TM 64474 0 2 0 1053 0
76930748 76930760 797 TM 60364 0 3 0 1053 0
769306B4 769306CC 797 TM 58038 0 2 0 1053 0
76930620 76930638 797 TM 57939 0 2 0 1053 0
7693058C 769305A4 797 TM 54933 0 2 0 1053 0
769304F8 76930510 797 TM 54913 0 2 0 1053 0
76930464 7693047C 797 TM 54906 0 2 0 1053 0
769303D0 769303E8 797 TM 54898 0 2 0 1053 0
7693032C 76930344 797 TM 54890 0 2 0 1053 0
76930298 769302B0 797 TM 54877 0 2 0 1053 0
76930204 7693021C 797 TM 54869 0 2 0 1053 0
76930170 76930188 797 TM 54831 0 2 0 1053 0
769300DC 769300F4 797 TM 54822 0 2 0 1053 0
76930048 76930060 797 TM 54820 0 2 0 1053 0
7692FFB4 7692FFCC 797 TM 54818 0 2 0 1053 0
7692FF20 7692FF38 797 TM 54808 0 3 0 1053 0
7692FE8C 7692FEA4 797 TM 54799 0 2 0 1053 0
7692FDF8 7692FE10 797 TM 54787 0 2 0 1053 0
7692FD64 7692FD7C 797 TM 54783 0 2 0 1053 0
7692FCD0 7692FCE8 797 TM 54774 0 2 0 1053 0
7692FC3C 7692FC54 797 TM 54767 0 2 0 1053 0
7692FBA8 7692FBC0 797 TM 54757 0 2 0 1053 0
7692FB14 7692FB2C 797 TM 54751 0 2 0 1053 0
7692FA80 7692FA98 797 TM 54594 0 2 0 1053 0
34 rows selected.
|
|
|
|
| Re: locking in oracle [message #145574 is a reply to message #145566] |
Thu, 03 November 2005 20:27  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
|
Did you do a commit/rollback just before the insert? How do you know some of these locks are not from prior statements?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
