Oracle Statistics


Does anyone know what is the definition of long table on v$sysstat's full table scans (long table) statistic?


A somewhat dated definition now that there are some huge tables out there, but a full table scan increments this value if the table is > 5 blocks.  If it's < 5 blocks, it increments the short tables value instead.
Hosted by www.Geocities.ws

1