Hello everyone,
We are currently developing an application to our company that uses Oracle 9i as the central repository. The applications we developed are .Net Applications, and we use Oracle ODAC 11g as our Data Access Library to the database. Every changes made to the database are transaction based, to ensure that there would be no "dirty writes". Also we have an application that uses the Bulk Insert function of oracle to write data. As we are performing tests on our applications, we noticed that writing performance slows down, even to the point when it would normally take 3 hours to write data, it would take more than 24 hours to do the same job. What I've noticed is that the TEMPORARY TAblespace of our DB is 99% full when this happens. Is there a way (in form of a script) to manually clear the TEMPORARY Tablespace of ORACLE, that would not involve DBA functions? I've recalled that there is a dedicated TEMP TAblespace for the schema we are using...