Hi folks,
I'm seeing an increase in Dialog response times on a clients ECC system (Windows/Oracle)
Average % DB Time over a month was 60.57% (< 40% recommended)
DB Buffer quailty is consistantly between 98-99%
DD Cache Quality is 99%
No issues with with recursive calls vs user calls.
Hit ratios all good in ST02 (98%-100%)
And yet, still we see % DB time over 60%
I've identified a number of DB intensive jobs/reports but they're not regular and the high % DB Time is fairly consistant throughout the month.
Any suggestions would be greatly appreciated.
Thanks.