Re: drop temp tablespace takes forever

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 18 Oct 2006 18:00:47 GMT

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: Brian Peasland <dba_at_nospam.peasland.net>
</span>
<span id="date"><dfn>Date</dfn>: Wed, 18 Oct 2006 18:00:47 GMT</span>
<span id="message-id"><dfn>Message-ID</dfn>: <J7CFDF.6y5_at_igsrsparc2&#46;<!--nospam-->er.usgs.gov>
</span>
</address>

<br>

maxim2k wrote:
<br>
<i class="quotelev1">> On 10/18/06 4:59 PM, Brian Peasland wrote:</i><br>

>> If users are actively using the tablespace, the DROP command will wait 
>> for those sessions to release their locks on that tablespace. How long 
>> this takes depends on the session's activity.

<br>
<i class="quotelev1">> </i><br>
<i class="quotelev1">> Is there any way to tell if this is the actual issue?</i><br>
<i class="quotelev1">> </i><br>
<i class="quotelev1">> I've tried to kill user sessions, but it didn't seem to help.</i><br>
<i class="quotelev1">> </i><br>
<i class="quotelev1">> Thanks.</i><br>

Why are you killing valid user connections? Won't your end users get upset about this? If not, then why not bounce the database?

Just some questions that immediately sprang to mind... :)

Cheers,
<br>

Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam&#46;<!--nospam-->peasland.net


<a href="http://www.peasland.net">http://www.peasland.net</a>


Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown


<span id="received"><dfn>Received on</dfn> Wed Oct 18 2006 - 13:00:47 CDT</span>

</div>

Received on Wed Oct 18 2006 - 13:00:47 CDT