Verify Outdated Optimizer Stats

From: Ram <krishna000_at_gmail.com>
Date: Mon, 16 Feb 2009 20:55:36 -0800 (PST)
Message-ID: <f05bf69c-f0a2-4bc3-9cd0-2c72f8345447_at_t39g2000prh.googlegroups.com>



Hi All,

I hope every one would have come across that users complaining about the response of database.Usually the first thought comes to the DBA is to Gather Stats and verify the performance.Performance will be far better after collecting stats and this is expected behavior.

Before users start complaining about the performance of database is very slow , Can't we verify the statistics for out database is that outdated. Can any one throw some light on this .

Regards

RAM. Received on Mon Feb 16 2009 - 22:55:36 CST

Original text of this message