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
--
//www.freelists.org/webpage/oracle-l


Other related posts: