Re: unlocking objects >

From: <rgaffuri_at_cox.net>
Date: Thu, 17 Jul 2003 8:07:48 -0400
Message-Id: <25946.338237@fatcity.com>

This is a multi-part message in MIME format.

------=____1058443668606_Y,JqtFo?aq
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

if the session is in 'KILLED' status it is rolling back the transaction.

you have to wait for this to finish. it can take a while.
>
> From: "Siddharth Haldankar" <shaldank_at_cisco.com>
> Date: 2003/07/17 Thu AM 06:24:25 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: unlocking objects >
>
> Hi Gurus,
>
>
>
> One of my object is locked. How do I unlock that object explicitly ?
>
> The session is already killed, but still the object appears in locked
> status.
>
>
>
> Thanks in advance
>
>
>
> With Warm Regards
>
> _____
>
> Siddharth Haldankar
>
> Cisco Systems Inc. ODC
>
> Zensar Technologies Ltd.
>
> # : 4128374
>
> shaldank_at_cisco.com
>
> s.haldankar_at_zensar.com
>
>
>
>
>

------=____1058443668606_Y,JqtFo?aq
Content-Type: text/html;

name="reply"
Content-Disposition: inline;

filename="reply"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html>

	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Courier New";}
p
	{margin-right:0in;
	margin-left:0in;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle18
	{font-family:Arial;
	color:blue;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
@page Section1
	{size:595.45pt 841.7pt;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}

-->
</style>

</head>

Hi Gurus,

One of my object is locked. How do I unlock that object explicitly ?

The session is already killed, but still the object appears in locked status.

Thanks in advance

<div>

With Warm Regards

</div>

Siddharth Haldankar

Cisco Systems Inc. ODC

Zensar Technologies Ltd.

#  : 4128374

shaldank_at_cisco.com

s.haldankar_at_zensar.com

</div>

<span Received on Thu Jul 17 2003 - 07:07:48 CDT