stale stats
From: RF <rf_at_hotmail.com>
Date: Sun, 16 Jan 2011 16:10:25 -0500
Message-ID: <59JYo.24178$231.1537_at_newsfe14.iad>
We keep running into suboptimal query plans with 11g and then we run into slow queries and once we collect stats, things get better again. How can we ensure our plans dont change as such ?
Date: Sun, 16 Jan 2011 16:10:25 -0500
Message-ID: <59JYo.24178$231.1537_at_newsfe14.iad>
We keep running into suboptimal query plans with 11g and then we run into slow queries and once we collect stats, things get better again. How can we ensure our plans dont change as such ?
Please advice. It is very frustrating and leads to downtime of our apps.. Received on Sun Jan 16 2011 - 15:10:25 CST