oracle maintains

S

shahji

Guest
I want to maintain the Temp file in the oracle which is basically the Temp Temporary Tablespace. The System is working around 3 years and there are more than 100 users. We never saw the temp Tablespace earlier. It has the size of more than 10 GB. I know the user?s queries and DML use it on the fly.

Can we maintain this file or any way that we can reduce the size of this file?

My server has the Database in Oracle 10g and the Operating System is LINUX Advance Server.
 
Back
Top