analyzing AWR report: buffer gets
Hi all,
On our prod server, one of the table is around 200MB. Our application are connected to database in "normal" way (what we know of). High CPU of around 50% by oracle processes were reported. We bounced the db and restarted the application. Now, CPU usage has gone drastically down to average (4-8%).
On analyzing AWR report for these two different one-hour window, noticed that a particular select query ran on tableA (size 200MB) for around 9000 times & number of rows processed were also quite similar in both cases. However, '%Total DB time' is 80% in first case, while it goes down to 4% in second case. While on 1st case, buffer gets was close to 230 million, it was around 2 million in second case.
On analyzing AWR report for these two different one-hour window, noticed that a particular select query ran on tableA (size 200MB) for around 9000 times & number of rows processed were also quite similar in both cases. However, '%Total DB time' is 80% in first case, while it goes down to 4% in second case. While on 1st case, buffer gets was close to 230 million, it was around 2 million in second case.
0