Exadata General (MOSC)

MOSC Banner

predicate offload

edited Feb 19, 2019 8:48PM in Exadata General (MOSC) 1 commentAnswered ✓

If a predicate offload (“cell physical IO bytes eligible for predicate offload”) is more than "physical read total bytes", does this mean its due to smart scan?

Other way round, if physical reads are more than predicate offload statistics, which 2 might be the reasons listed below to be the cause?

1) IOT table

2) index clustered table

3) uncommited transaction causing changed blocks

4) migrated rows on the table

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