OraFAQ Forum: Server Administration » user block

Home » RDBMS Server » Server Administration » user block - blocking session count (solaris10/oracle10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user block - blocking session count [message #296054]

Thu, 24 January 2008 06:54

dirish
Messages: 232
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

Report message to a moderator

Re: user block - blocking session count [message #296056 is a reply to message #296054]

Thu, 24 January 2008 07:16

Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Help in what?

Regards
Michel

Report message to a moderator

Re: user block - blocking session count [message #296469 is a reply to message #296054]

Sun, 27 January 2008 16:47

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.

Report message to a moderator

Re: user block - blocking session count [message #296470 is a reply to message #296054]

Sun, 27 January 2008 16:47

larrycatt
Messages: 3
Registered: January 2008
Location: Virginia Beach, VA

Junior Member

Sorry the view is v$locked_object

Report message to a moderator

Re: user block - blocking session count [message #296471 is a reply to message #296054]

Sun, 27 January 2008 17:03

BlackSwan
Messages: 26766
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
/

Report message to a moderator

Re: user block - blocking session count [message #302472 is a reply to message #296054]

Mon, 25 February 2008 19:27

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

Report message to a moderator

Re: user block - blocking session count [message #302512 is a reply to message #302472]

Tue, 26 February 2008 00:13

Michel Cadot
Messages: 68683
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 05:55:40 CDT 2024