Physical read IO requests higher than total [message #681978] |
Tue, 22 September 2020 12:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a620b814200ca16848607df637c45590?s=64&d=mm&r=g) |
pallen38
Messages: 4 Registered: September 2020
|
Junior Member |
|
|
I must be missing something really dumb, but I can't figure out why "Physical read IO requests" would be higher than "Physical read total IO requests." For instance:
physical read IO requests 380,456,786 10,560.10 1,041.47
physical read total IO requests 230,868,337 6,408.07 631.98
Even the documentation says that "physical read IO request" is supposed to be a subset of "total."
What am I missing?
Thanks!
Patrick
|
|
|
|
|
|
|
|
Re: Physical read IO requests higher than total [message #681984 is a reply to message #681983] |
Tue, 22 September 2020 14:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/a620b814200ca16848607df637c45590?s=64&d=mm&r=g) |
pallen38
Messages: 4 Registered: September 2020
|
Junior Member |
|
|
I have attached the portion of the AWR that has the relevant info. If more is needed let me know, and I will work on anonymizing the rest.
The part I have a hard time understanding is the physical IO requests:
physical read IO requests..........380,456,786
physical read total IO requests...230,868,337
|
|
|