Re: temporary space usage

From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
Date: Wed, 13 Jun 2007 12:45:21 -0400

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@xxxxxxxxxxxxxxxxxxxxx
<genegurevich@xxxxxxxxxxxxxxxxxxxxx> 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

Follow-Ups:

Re: temporary space usage
From: genegurevich

References:
- temporary space usage
  - From: genegurevich

Other related posts:

Browse oracle-l