Started evaluating the performance of a production system as a new project we undertook. APEX pages were slow to load, responsiveness was also slow. After some research, we found out that WWV_FLOW_DATA table had 732 million rows and WWV_FLOW_SESSIONS$ had 193 million rows (APEX_040200 schema). The cause: someone had droppped the scheduled job ORACLE_APEX_PURGE_SESSIONS!
Read More
© 2024 AllDataFound