Re: temp tablespace blow up

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 17 Aug 2007 13:22:34 +0100
Message-ID: <7765c8970708170522i320615e3qdadc9080404d5cda@mail.gmail.com>

nice tip. I've also been lied to, but had no way of proving it :)

On 8/17/07, Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
>
> Btw, the v$sort_usage & v$tempseg_usage have "lied" for me before (due
> bugs or anomalies).
>
> If you're just interested in how much free space there's available for you
> then use v$temp_extent_pool...
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 17 2007 - 07:22:34 CDT