Locker and waiter problem [message #490523] |
Tue, 25 January 2011 07:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3f2b1fc1c77d7a5067b1abc9477a0a4d?s=64&d=mm&r=g) |
swadeshi
Messages: 15 Registered: January 2011 Location: Bangalore
|
Junior Member |
|
|
Hi I am new to performance tuning please let me know how to gop about it ?? One procedure is blocking and another is locking it.
SQL> @glockers
Oracle OS
INSTANCE SID TY Usernam SERIAL# SPID Process LMODE REQUEST
---------- ------ -- ------- ---------- ------------ ------- ------------------------------------ ------------------------------------
STATE
----------------------------
SQL_TEXT
------------------------------------------------------------------------------------------------------------------------------------- ----------------------
1 5372 JI XECC 27830 11633 4176 Exclusive None
BLOCKER
BEGIN cc_resync_xeccdb; END;
5 5366 JI XECC 50268 17090 8456 None Exclusive
WAITER
BEGIN cc_resync_FWSS_CS_data; END;
|
|
|
Re: Locker and waiter problem [message #490524 is a reply to message #490523] |
Tue, 25 January 2011 07:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
And? This is life, one is taking a resource and another one is waiting for it. I don't see any problem about this unless the first one never releases the resource.
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
Also post your script code we can estimate if what it returns is valid or not.
Regards
Michel
[Updated on: Tue, 25 January 2011 07:40] Report message to a moderator
|
|
|