Skip to Content
0
Former Member
May 16, 2014 at 01:51 PM

High % DB Time

358 Views

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.