| performance issue wtith single instance database [message #427764] |
Sun, 25 October 2009 03:42  |
|
|
Hi dears,
i am having problem with one of our production server is geting lock . when searched for trace files i goted. below is the output from trace files.
SO: 0x777935bc, type: 51, owner: 0x784c98b0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=777935bc handle=76ae2be0 mode=N
call pin=(nil) session pin=0x7779460c
user=784c98b0 session=784c98b0 count=1 flags=[00] savepoint=2
LIBRARY OBJECT HANDLE: handle=76ae2be0
than i need to kill the blocking session.
please me to solve the issue .
thanks in advance.
regards,
sher khan
|
|
|
|
| Re: performance issue wtith single instance database [message #427765 is a reply to message #427764] |
Sun, 25 October 2009 03:50  |
|
|
Hi dears,
when i queried database as
select * from v$lock where type='TX' and lmode>0;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
-------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
78F1D804 78F1D910 25 TX 65542 409524 6 0 1043 0
78F3F1B0 78F3F2BC 32 TX 131106 409338 6 0 4694 0
78F48490 78F4859C 52 TX 262144 418270 6 0 1669 0
78F51F28 78F52034 60 TX 327697 421237 6 0 226 0
78F238F0 78F239FC 85 TX 589870 417149 6 0 246 0
78F47CE8 78F47DF4 106 TX 196636 410720 6 0 3972 0
78F0D0F4 78F0D200 117 TX 786444 25695 6 0 336 0
78F60B4C 78F60C58 128 TX 655404 418661 6 0 3129 0
78F2351C 78F23628 139 TX 524319 422045 6 0 3475 0
9 rows selected.
thanks
|
|
|
|
|
|
| Re: performance issue wtith single instance database [message #427787 is a reply to message #427764] |
Sun, 25 October 2009 09:22 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
id1, id2, lmode, request, type
FROM V$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM V$LOCK WHERE request>0)
ORDER BY id1, request
/
returned rows indicate a problem
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
