Oracle Scratchpad

September 12, 2011

System Stats

Filed under: Bugs,CBO,Oracle,Statistics,System Stats,Upgrades — Jonathan Lewis @ 5:40 pm BST Sep 12,2011

A quick collation – and warning – for 11.2

Bottom line – be careful about what you do with system stats on 11.2

Addendum: one of the people on the two-day course I’ve just run in Berlin sent me a link for a quick note on how to set your own values for the system stats if you hit this bug. It’s actually quite a reasonable thing to do whether or not you hit the bug given the way that gathering the stats can produce unsuitable figures anyway:  setting system stats. (I’ve also added their company blog to the links on the right, they have a number of interesting items, and post fairly regularly.)


  1. Thanks Jonathan! I was writing about this on CDOS recently, as a matter of fact, the debate was about the bug mentioned in your post.

    Comment by Mladen Gogala — September 12, 2011 @ 10:35 pm BST Sep 12,2011 | Reply

    • Mladen,

      It was your post that prompted me to collate a few notes I’d seen on the topic.
      I’ve just added a link to another note that points out that you can always fake the system stats anyway – which I prefer to do rather than gathering them anyway.

      Comment by Jonathan Lewis — September 16, 2011 @ 8:33 am BST Sep 16,2011 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: