• Database

    The NO_INVALIDATE Option in DBMS_STATS with 10g

    I had worked hard on a report, 47 SQL statements in all to tune it down from 5 hrs to under 30 minutes.  The first runs had been quite successful, so when a third run sent an alert on temp usage, I knew something was wrong. SID PROCESS MACHINE SQL_TEXT SQL_ID TOTAL MB -------- ------------ -------------------- --------------------- 507 1137 HOST SELECT *** 7t3muww36xhzn 45516 600 1139 HOST SELECT *** 7t3muww36xhzn 45516 525 1132 HOST SELECT *** 7t3muww36xhzn 45516 509 1135 HOST SELECT *** 7t3muww36xhzn 45516 I checked the stats first, as one of the fixes was to ensure the staging…