doc

    Name:   tabstats.sql

    Author: Mark Gurry


The following script lists various statistics to do with table fetches,
including the number of chained rows (table fetch continued row), and
short and long table full table scans. 

#

ttitle 'Table Access Methods'

select name, value 
	from v$sysstat
where  name like '%table %'
order by name;