Database Tuning (MOSC)

MOSC Banner

v$SESS_IO field and number description

edited May 13, 2010 11:59PM in Database Tuning (MOSC) 2 commentsAnswered
Hi,
  could anyone explain to me what does the numbers in v$SESS_IO mean? The Oracle manual is completely silly for this, saying eqations like "Physical reads = number of physical reads".
I need to know what really counts into the "physical reads" and what does the number mean. Is it number of bytes, records, tablespace blocks, disk blocks, filesystem blocks, extents, Fiji shells, ... This information is completely missing.
  And I would be really grateful for description of all the fields.

Thanks
Jan

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