Hi All ,

The database in our organisation have around 350 MB
of Temporary tablespace. I often run the query

select tablespace_name , sum(bytes)/(1024* 1024)
from dba_free_space group by tablespace_name

I always see the tempory tablespace having less than
5MB of Free space even when there is no transactions for
a long time. As far as I have understood temporary
tablespace are used, mostly for transactions requiring
sort operation that does not fit in SGA memory and is
released when the transaction is complete.

My questions are

Is it something normal ?
Does it have any negative impact on the performance ?
If so then how to release space other than dropping
and recreating the temporary tablespace ?

My storage parametes for temporary tablespace are
Inital 400 K , Next 400 K , Pctincrease 0 , & AutoExtend enabled.

Thanking you in advance