| Locker and waiter problem [message #490523] |
Tue, 25 January 2011 07:37  |
 |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
