Such as topic, the hard disk read and write a lot of temp01. DBF cause server caton, is through the Windows resource monitor found, disk activity, and find the oracle. Exe in a large number of reading and writing temp01. DBF, leads to the longest activity time held at 100%, cause server card, please everybody help to analyze what is going on,

CodePudding user response:

Play a who runs AWR report, look at the TOP N the SQL, and focus on the ORDER BY IO part,

CodePudding user response:

If temporary table space is really tight currently, it is recommended that the query v $sort_usage view, combining with the v $session, v $SQL, you can know the current cost of temporary tablespace SQL and what is operation, and make the corresponding optimization, if now is calm, then use ~ # 1 building methods