Database Tuning (MOSC)

MOSC Banner

ADDM consistently shows very high physical reads and direct reads for a table

edited May 4, 2021 10:03AM in Database Tuning (MOSC) 6 commentsAnswered ✓

Hello everybody, I am a newby here so I apologize if I miss something in my question.

I have a plain oracle instance, Enterprise Edition version 12.2.0.1.0 - 64bit (Host has Microsoft OS).

·      db_block_size            = 8192

·      memory_target          = 2.634.022.912

·      open_cursors             = 300

·      processes                 = 300

My ADDM report is taken for one hour activity period, on four Mondays.

Every ADDM shows very high physical reads and direct reads for the same table . this is the core table of the application so no wonder it is so frequently accessed but I am a bit puzzled by the values I read.


the tablespace is configured as follows:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center