Re: temporary space usage

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Wed, 13 Jun 2007 12:45:21 -0400
Message-ID: <49d668000706130945j54f8c098gb94a86992efbc494@mail.gmail.com>

The segments will be reused by the another processes as needed. Oracle keeps them so it doesn't need to create them again each time someone wants it.

On 6/13/07, genegurevich_at_discoverfinancial.com <genegurevich_at_discoverfinancial.com> wrote:

> Does the bottom query indicates that the TEMP TS is used by some temporary
> segments, which will be reused by any
> process that needs TEMP ts and therefore is misleading? Or is there another
> explanation?
>
> thank you
>
> Gene Gurevich
>

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

Received on Wed Jun 13 2007 - 11:45:21 CDT