Home » RDBMS Server » Server Administration » user block - blocking session count (solaris10/oracle10g)
user block - blocking session count [message #296054] Thu, 24 January 2008 06:54 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
In my EM console, I am having this error:

e.g 'session 1511 is blocking 4 other session'


Can you please help

Thank you,
Dirish
Re: user block - blocking session count [message #296056 is a reply to message #296054] Thu, 24 January 2008 07:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Help in what?

Regards
Michel
Re: user block - blocking session count [message #296469 is a reply to message #296054] Sun, 27 January 2008 16:47 Go to previous messageGo to next message
larrycatt
Messages: 3
Registered: January 2008
Location: Virginia Beach, VA
Junior Member
You have a session which is blocking access to an object.
Look in v$locked_objects where session_id=1511.
Re: user block - blocking session count [message #296470 is a reply to message #296054] Sun, 27 January 2008 16:47 Go to previous messageGo to next message
larrycatt
Messages: 3
Registered: January 2008
Location: Virginia Beach, VA
Junior Member
Sorry the view is v$locked_object
Re: user block - blocking session count [message #296471 is a reply to message #296054] Sun, 27 January 2008 17:03 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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
/
Re: user block - blocking session count [message #302472 is a reply to message #296054] Mon, 25 February 2008 19:27 Go to previous messageGo to next message
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
Junior Member
You must to understain that the LOCK is a protect mechanism for integrity of data

You must see ever

the type of lock

the time waiting

the sessions in wait

the results if you choose kill the block session

In grid control console the information is very excepcional and you can evaluate the risks and finaly put the best action

Regards
Re: user block - blocking session count [message #302512 is a reply to message #302472] Tue, 26 February 2008 00:13 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hmm, I think after one month the lock has been released. Smile

Regards
Michel
Previous Topic: how to compute the total memory consume of oracle sessions
Next Topic: Cloning tablespace
Goto Forum:
  


Current Time: Sun Dec 04 20:41:28 CST 2016

Total time taken to generate the page: 0.18647 seconds