Database Administration (MOSC)

MOSC Banner

Chained Rows Read Ratio ( formula )

edited Sep 21, 2023 3:02PM in Database Administration (MOSC) 5 commentsAnswered

What "Chained Rows " means is clear so far. Here is a good description: arkadio.com

But is there a formula for the evaluation "Chained Rows Read Ratio" ?

In the AWR report a lot of statistics exists ( Source: Statistics ) :

  • tfcr = table fetch continued row (Chained Rows)        : Number of times a chained or migrated row is encountered during a fetch
  • tfbr = table fetch by rowid     (Index-Use)           : Number of rows that are fetched using a ROWID (usually recovered from an index)
  • tsrg = table scan rows gotten   (Full Table Scan Rows) : Number of rows that are processed during scanning operations
  • slrd = session logical reads    (sum "db block gets" + "consistent gets" ) : The sum of "db block gets" plus "consistent gets".

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