| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Storage useage in temporary tablespaces.
Hi Bill,
My understanding is that when a tablespace is designated as temporary, space is allocated when sorts are performed and NOT de-allocated. The allocated space is then used the next time a query needs to sort. The space is not de-allocated to cut down on the overhead of allocating temp space. Yes it looks weird when you look at it from a tablespace point of view (my DW has 4.5 GB allocated, 7GB total, NO ONE using the system). Don't worry about it.
Lisa
Bill Wagman <wjwagman_at_ucdavis.edu> on 04/27/2000 09:11:54 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)
Subject: Storage useage in temporary tablespaces.
I am confused a bit about storage in a temporary tablespace. The tablespace is 500MB with an initial and next of 256KB and maxextents set to 2000. When I look at the free space there is only 5MB of free space and no one is doing anything. I don't understand why the space shows up as being allocated. Can someone explain please.
Thanks.
Bill Wagman
Univ. of California at Davis
Information Resources
wjwagman_at_ucdavis.edu
(530) 754-6208
-- Author: Bill Wagman INET: wjwagman_at_ucdavis.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Apr 28 2000 - 08:53:00 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |