Hi All,

I have Oracle9i Enterprise Edition Release 9.2.0.1.0 – Production database
and the size is around 130GB with Archive log on and taking daily complete
hot backup.
My problem is database is not cleaning TEMP Tablespace as fast as Oracle
8i.

Will creating a new Tablespace for temp solve the problem? Is there any
work-around?

Regards
Rajesh
Oracle LazyDBA home page