Last week I got to look at a version 9 Statspack Report from a database where the buffer cache was set to 32M. That’s right, 32M. I don’t think you can buy a thumb drive that small. They were using 16K blocks too, so what’s that:
(32*1024*1024)/(16*1024) = 2,048 blocks
Not very many blocks for that database. Needless to say it wasn’t working very well for the multi-hour batch job they were trying to run.
Then over the weekend someone sent an AWR report from a version 10 database and it had a 60G buffer cache. That’s the biggest one I’ve ever seen!
So it was a pretty interesting week (from a geeky technical standpoint anyway)!
It reminded me of Muggsy Bogues guarding Shawn Bradley, or Manute Bol, or MJ, or just about anybody.
Anyone seen a bigger (or smaller) buffer cache recently?
I’d love to hear about it.