This is very good place to share the knoledge.
Can everybody put down their methods to find Full Table Scan on Database.
How Oracle Decides in v$sysstat between
"table scans (long tables)" and "table scans (short tables)"
Printable View
This is very good place to share the knoledge.
Can everybody put down their methods to find Full Table Scan on Database.
How Oracle Decides in v$sysstat between
"table scans (long tables)" and "table scans (short tables)"
Explain plan and tkprof
If I remember right, large scan is considered when the size of table is larger than 2% or 4% of db block buffer