Cached Tables

 

Cached Tables

CACHED TABLE NOTES:

Owner - Owner of the table

Table Name - Name of the table

Cache - Cached?

Oracle 7.1+ provides a mechanism for caching table in the buffer cache. Caching tables will speed up data access and improve performance by finding the data in memory and avoiding disk reads.

select  OWNER,
 TABLE_NAME,
 CACHE
from dba_tables
where OWNER not in ('SYS','SYSTEM')
and CACHE like '%Y'
order by OWNER,TABLE_NAME