OraFAQ Forum: Performance Tuning » Physical read IO requests higher than total

Home » RDBMS Server » Performance Tuning » Physical read IO requests higher than total (12.2, Linux 64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Physical read IO requests higher than total [message #681978]

Tue, 22 September 2020 12:36

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

Report message to a moderator

Re: Physical read IO requests higher than total [message #681979 is a reply to message #681978]

Tue, 22 September 2020 13:01

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

Provide the query you used.

Report message to a moderator

Re: Physical read IO requests higher than total [message #681980 is a reply to message #681978]

Tue, 22 September 2020 13:09

pallen38
Messages: 4
Registered: September 2020

Junior Member

Sorry, my version is 12.1.0.2.0 and this is on Linux (64 bit)

Report message to a moderator

Re: Physical read IO requests higher than total [message #681981 is a reply to message #681980]

Tue, 22 September 2020 14:05

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And your query was?

Report message to a moderator

Re: Physical read IO requests higher than total [message #681982 is a reply to message #681981]

Tue, 22 September 2020 14:10

pallen38
Messages: 4
Registered: September 2020

Junior Member

There were a lot of queries - this was an AWR report over 10 hours.

Report message to a moderator

Re: Physical read IO requests higher than total [message #681983 is a reply to message #681982]

Tue, 22 September 2020 14:32

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I meant the query that gave the result you posted.

Or post the extract of the AWR report which shows these figures.

[Updated on: Tue, 22 September 2020 14:33]

Report message to a moderator

Re: Physical read IO requests higher than total [message #681984 is a reply to message #681983]

Tue, 22 September 2020 14:56

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

Attachment: awr_part.html.txt
(Size: 97.89KB, Downloaded 2917 times)

Report message to a moderator

Previous Topic:	New to tuning
Next Topic:	Different SQL ID for same SQL/HASH_VALUE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 17:59:28 CST 2025