Note: This blog entry was originally created by Zach Zhang in the Asset Management Group. I wanted to share this info with the Process Automation Group too. There's some intermediate resource required by Oracle database to execute sql statements. One among them is Oracle Temporary Table Space when pure-in-memory operations could not be performed due to resource limitation or specific execution plan. As Oracle doc says:" A temporary tablespace contains transient data that persists only for the duration of the session" .
So likely,... [More]