Database Tuning (MOSC)

MOSC Banner

dba_hist_sysstat physical read , physical write

edited Jun 14, 2016 3:27PM in Database Tuning (MOSC) 5 commentsAnswered

Hi,

In view dba_hist_sysstat  the value of  stat_name='physical reads' and physical writes  is it number of blocks reads and writes or IOPS ?

Please clarrify !

physical reads    11270057596

physical writes   167963168

I have two questions :-

1) Is it number of blocks reads and writes or IOPS

2) Is it logical read and write or physical ?

Thanks,

Mukesh

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