Stats note

This is just a temporary link to Randolf Geist’s note on a small, but potentially significant, change in the way that Oracle handles statistics when you’re fiddling with indexes and empty tables. I’ve added the link to my “bits and pieces” list (see top right) so I’ve disabled comments and will be deleting this post in a few days.

And here’s a link to a really smart piece of SQL from Timur Ahkmadeev which uses v$sysmetric to emulate the output of the statspack/AWR profile over the last few seconds. (This one’s going into the AWR/Statspack list – also in the catalogue at top right).