Home » RDBMS Server » Performance Tuning » performance issue wtith single instance database (linux 2 Advance server)
performance issue wtith single instance database [message #427764] Sun, 25 October 2009 03:42 Go to next message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

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 Go to previous messageGo to next message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

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 #427775 is a reply to message #427765] Sun, 25 October 2009 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Output is unreadable when columns are not align.
Please read OraFAQ Forum Guide, especially "How to format your post?" section and use code tags.

Regards
Michel
Re: performance issue wtith single instance database [message #427787 is a reply to message #427764] Sun, 25 October 2009 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 24905
Registered: January 2009
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
Re: performance issue wtith single instance database [message #427856 is a reply to message #427787] Mon, 26 October 2009 04:08 Go to previous messageGo to next message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

Hi dear,

now the output is 0 rows . let me check the same query during lock time and will provide you output.than will seee.


thanks
Re: performance issue wtith single instance database [message #429464 is a reply to message #427856] Wed, 04 November 2009 00:04 Go to previous message
sherkhan@infodynamic.net
Messages: 28
Registered: August 2009
Location: dubai
Junior Member

Hi dear,


output of the query is

Holder: 97 30895 0 3 0 TM
Waiter: 119 30895 0 0 2 TM
Waiter: 82 30895 0 0 3 TM
Waiter: 124 30895 0 2 4 TM



thanks and can u please put some comments on this what is showing in the result.


thanks & regards,
sher khan
Previous Topic: ORA-02097 AND ORA-00439
Next Topic: SQL statements were not shared due to the usage of literals. This resulted in additional hard parses
Goto Forum:
  


Current Time: Mon Sep 26 14:33:22 CDT 2016

Total time taken to generate the page: 0.31641 seconds