Permalink Submitted by dave on Tue, 01/28/2014 - 20:19.
Thanks for the comment. I fired up Statspack for an 8i database last night. First time in a long time but it gave me enough info so I was able to solve the problem. Normally I'm not a "Ratio Tuner" but the Buffer Cache Hit was a miserable 2% so we were definitely starved with 8mb of DB Buffer Cache for a 1000mb database. I had to read the instructions on how to install, I am so spoiled with AWR these days!
Thanks for the comment. I
Thanks for the comment. I fired up Statspack for an 8i database last night. First time in a long time but it gave me enough info so I was able to solve the problem. Normally I'm not a "Ratio Tuner" but the Buffer Cache Hit was a miserable 2% so we were definitely starved with 8mb of DB Buffer Cache for a 1000mb database. I had to read the instructions on how to install, I am so spoiled with AWR these days!