stale stats

From: RF <>
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

Original text of this message