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,
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