I have oracle8i running on the NT box. I am the sole person on
using that oracle database in that box. Somehow temp tablespace of
box is using 4G of space. I don't remember I have allocated that much
of space for that table space.

Oracle8i on that box is running in noarchivelog mode. I am writing a perl
application to use that database, somehow my perl application screwed up
with Operating System. So I had to shutdown the machine, when I reboot
the machine it was taking very long time to mount the database. I know
that temp tablespace did not have that 4G of space before, after a while
when database is completely mounted, I saw that temp
tablespace is occupying that much space.

By the way I have other tablespace which has 3G of space for my application.


Can somebody give me idea to tune 4G of temp tablespace?

Any idea and suggestion are welcome.
Thanks in advance.

SKM