|
Hi!
How much free space you have in your file system,
you might be hitting the sparse files issue...
Tanel.
----- Original Message -----
Sent: Thursday, October 23, 2003 10:49
PM
Subject: ** temp tablespace
Hi,
I have a huge temp tablespace (4GB) and not much usage
(current usage is 50MB from v$ tables) . However it keeps running
out of space. It ran out of space yesterday and I was hoping it would
release but it got an error again. The database is only 35GB mostly small
tables. IT is temporary (contents). How can i tell how much is *actually*
free. dba_free_space shows hardly any free even when there is no activity.
Thanks
Do you Yahoo!?
The
New Yahoo! Shopping - with improved product
search
|
