Rows processed by a sql but not retrieved

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..  †Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Sat Feb 06 2021 - 02:21:40 CET