Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: temp tablespace blow up
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-lReceived on Fri Aug 17 2007 - 07:22:34 CDT
![]() |
![]() |