Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Storage useage in temporary tablespaces.

Storage useage in temporary tablespaces.

From: Bill Wagman <wjwagman_at_ucdavis.edu>
Date: Thu, 27 Apr 2000 17:55:28 -0700
Message-Id: <10480.104367@fatcity.com>


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



Why is it that when you're driving and looking for an address, you turn down the volume on the radio? Received on Thu Apr 27 2000 - 19:55:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US