On my website is a white paper titled Solving User Problems. Page 3 discusses how to find the SID for your session. Once you've identified the SID of the session that is having the difficulty, then look to pages 6-8 to see if another session is holding a lock. If there is no lock, then look to pages 15-17 to see what wait events are holding up the session.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.