Dear gurus,
In order to measure the db performance do we need to measure performance at O/S level first? My database is 10.2.0.4 and sometimes the performance degrades when i check the sar for cpu and sar -r i get the below output
07:40:01 AM all 8.00 0.00 0.61 7.30 0.00 84.10
07:50:01 AM all 9.18 0.00 0.33 2.92 0.00 87.57
08:00:01 AM all 6.79 0.00 0.14 1.13 0.00 91.94
08:10:01 AM all 7.02 0.00 0.15 2.13 0.00 90.70
08:20:01 AM all 6.92 0.00 0.40 1.20 0.00 91.48
08:30:01 AM all 6.88 0.00 0.08 1.08 0.00 91.96
08:40:01 AM all 7.10 0.00 2.27 0.97 0.00 89.66
08:40:01 AM CPU %user %nice %system %iowait %steal %idle
08:50:01 AM all 5.77 0.00 0.08 0.99 0.00 93.16
09:00:01 AM all 2.01 0.00 0.72 1.58 0.00 95.68
09:10:01 AM all 4.28 0.00 4.82 4.48 0.00 86.42
09:20:01 AM all 3.36 0.00 2.90 1.21 0.00 92.53
09:30:01 AM all 3.19 0.00 4.83 1.69 0.00 90.28
09:40:01 AM all 2.44 0.00 5.68 1.71 0.00 90.17
09:50:01 AM all 2.97 0.00 5.79 1.85 0.00 89.39
10:00:01 AM all 3.16 0.00 5.80 2.12 0.00 88.92
10:10:01 AM all 3.41 0.00 6.23 2.25 0.00 88.11
10:20:01 AM all 2.74 0.00 5.88 2.72 0.00 88.66
Average: all 4.49 0.00 0.83 2.02 0.00 92.66
Memory side:
08:00:01 AM 1300992 31633160 96.05 223508 27178252 77825708 0 0.00 0
08:10:01 AM 1177260 31756892 96.43 226340 27171224 77825708 0 0.00 0
08:20:01 AM 1203840 31730312 96.34 227060 27184876 77825708 0 0.00 0
08:30:01 AM 1194952 31739200 96.37 227716 27114816 77825708 0 0.00 0
08:40:01 AM 1119596 31814556 96.60 230708 27382436 77825708 0 0.00 0
08:40:01 AM kbmemfree kbmemused %memused kbbuffers kbcached kbswpfree kbswpused %swpused kbswpcad
08:50:01 AM 1085820 31848332 96.70 233628 27442632 77825708 0 0.00 0
09:00:01 AM 451268 32482884 98.63 231548 27964424 77825708 0 0.00 0
09:10:01 AM 232128 32702024 99.30 246216 27813872 77505916 319792 0.41 259304
09:20:01 AM 111708 32822444 99.66 247344 27974912 77507496 318212 0.41 257860
09:30:01 AM 107876 32826276 99.67 247256 27873888 77512712 312996 0.40 268168
09:40:01 AM 124372 32809780 99.62 246904 27859108 77519360 306348 0.39 262592
09:50:01 AM 112492 32821660 99.66 247128 27865504 77565248 260460 0.33 207956
10:00:01 AM 140792 32793360 99.57 235388 27706788 77585124 240584 0.31 189256
10:10:01 AM 110360 32823792 99.66 232812 27482076 77581128 244580 0.31 188176
10:20:01 AM 103536 32830616 99.69 208152 27436368 77471452 354256 0.46 248528
Average: 1455448 31478704 95.58 251162 27066271 77787688 38020 0.05 30352
In this case, the SGA size 27GB and total server memory is 32GB, does it mean the sar output will always show 27GB as used?
Thanks
qA