Understand Oracle Temp Usage of Maximo
zachzhang 270003DPUQ Visits (4579)
As Oracle doc says:"A temporary tablespace contains transient data that persists only for the duration of the session". So likely, if you have many things produced in the middle of query, you will probably need a temporary space to put such intermediate stuff in.
Before we start to discuss how and when Maximo application will use temp in Oracle database, there's one thing worth mentioning: it's Oracle database to decide when and how to use the Temp segment, while any application code just want the query result.
We simulated a lack of memory situation, which will for Oracle to use temporary space more frequently. Steps:
Observation 1: Stay in the same app(e.g. WO), user keep active.
If user continues working in the same app, select some items or switch TABs inside the same application (e.g. WO), the TEMP was not rele
If user stay idle in the same app, the TEMP was released after a session timeout (default 30 minu
After switch to another application, (e.g. from WO to ASSET), the TEMP was rele
After a normal log out, the TEMP is rele
If user close the browser directly, the application has no idea if the user finished using the result set. So it will wait for a session timeout and cleanup the TEMP.
No doubt that the best way is to avoid using Temp, pure in-memory operations have the best performance. But if your Oracle database doesn't have enough memory configuration, you'd better train your end user more carefully or tune the sql statement to run more efficient with Oracle database.