Tuesday, April 16, 2013

Oracle Stats Gathering During Automated Maintenance Tasks Window

Problem Background
A few days back I faced a problem when I received slowness complaints from end users who use an application based on our 11.1.0.7 database. While investigating, I came to know that at 10:00 AM, a stats gathering job started which lasted for 45 minutes and during this window,

Popular Posts - All Times