OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » release lock..??

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

release lock..?? [message #139347]

Tue, 27 September 2005 10:27

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai ,

we need to release the locks made to the objects in the schema.
how to release the locks made by user.?

plz help out with commands ..

regards
bala

Report message to a moderator

Re: release lock..?? [message #139438 is a reply to message #139347]

Wed, 28 September 2005 00:47

Kavitha Suresh
Messages: 22
Registered: September 2005

Junior Member

run catblock.sql found in $ORACLE_HOME/rdbms/admin using SVRMGRL when
connected as SYS or INTERNAL

Report message to a moderator

Re: release lock..?? [message #139443 is a reply to message #139438]

Wed, 28 September 2005 01:01

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

hi,

First of all, Identify the session which is holding the lock then do

1. Ask to commit/rollback their transaction so that locks could be released.

or

2. Kill those session ( resolving contention in emergency)

regards,
tarun

Report message to a moderator

Re: release lock..?? [message #139604 is a reply to message #139347]

Wed, 28 September 2005 15:30

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Here is another way ..
select sid, logon_time from v$session
where sid in (
Select sid from v$access where object='&OBJECT_SUSPECTED_TOB_LOCKED')
order by logon_time;

Kill the old sessions by finding their spid's

Hope that helps
-Sai Jeedigunta

Report message to a moderator

Previous Topic:	increasing size of RBS..?
Next Topic:	Error during stoping of service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 10:21:17 CST 2025