Negative Cache Hit Ratio
Seems that when performing certain actions in Oracle, like reindexing or other IO Heavy tasks, theese are by Oracle not counted as Logical I/O but only as Physical I/O. That causes the LILOM Cache Hit Ratio counter to return a negative percentage (Since Logical IO is for example 5 and Physical Reads at the same time 3000 per second.) Needs to be set to zero if a calculated percentage returns a negative result.
-
Please register or sign in to post a comment