Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
![]() |
![]() |