Doc

     Name:   tabcache.sql

     Author: Mark Gurry

     This script lists all tables that are currently
     cached.
#

ttitle 'Cached Table Listing' 

SELECT owner, table_name, cache
FROM   all_tables
WHERE  owner not in ('SYS', 'SYSTEM')
AND    cache not like 'N%';

