Re: drop temp tablespace takes forever

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: Mike Towery <mtowery_at_gmail.com>
</span>
<span id="date"><dfn>Date</dfn>: 18 Oct 2006 09:07:47 -0700</span>
<span id="message-id"><dfn>Message-ID</dfn>: <1161187667.434219.66910_at_f16g2000cwb&#46;<!--nospam-->googlegroups.com>
</span>
</address>

<br>

Try querying the view below to see who is sorting to the temp tablespace in question.

select * from v$sort_usage;

maxim2k wrote:
<br>
<i class="quotelev1">> On 10/18/06 4:59 PM, Brian Peasland wrote:</i><br>
<i class="quotelev2">> > If users are actively using the tablespace, the DROP command will wait</i><br>
<i class="quotelev2">> > for those sessions to release their locks on that tablespace. How long</i><br>
<i class="quotelev2">> > this takes depends on the session's activity.</i><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>
<span id="received"><dfn>Received on</dfn> Wed Oct 18 2006 - 11:07:47 CDT</span>
</div>
Received on Wed Oct 18 2006 - 11:07:47 CDT