DBMS_STATS
From: The Magnet <art_at_unsu.com>
Date: Mon, 28 Sep 2009 08:42:33 -0700 (PDT)
Message-ID: <2c91e85c-bfb3-410a-9cfe-81c52c3c38b8_at_k26g2000vbp.googlegroups.com>
Date: Mon, 28 Sep 2009 08:42:33 -0700 (PDT)
Message-ID: <2c91e85c-bfb3-410a-9cfe-81c52c3c38b8_at_k26g2000vbp.googlegroups.com>
Probably a dumb question here, but we're trying to understand DBMS_STATS and all the parameters and such. What a complicated thing. Too many parameters to understand the effects.
Anyhow, I read that Oracle 10g generates database stats each night. What kind of stats? Does this mean I do not have to compute schema stats? Received on Mon Sep 28 2009 - 10:42:33 CDT