Hello listers
Regardless of what oracle calls them in many views, let’s say a sql (no
exadata) gets more rows than its need (like a filter predicate not an access
one) which means we will be throwing away unneeded rows..
Is there a stat or a way to tell how many rows were thrown away as not needed?
For instance I saw at a friend shop that when they hit exacta storage cell it
affects IO and it makes smart scan degrades terribly and it is not clear if
smart scan are not actually (cell off loading anymore) or just became slower
with the issue..