查看buffer_cache中缓存的对象要使用的视图:
dba_objects
v$bh
1.执行下面语句,看scott用户数据在buffer_cache缓存情况。
SYS@ oracle1 as AS SYSDBA>select o.object_name,count(1) blocks from dba_objects o,v$bh bh where o.object_id=bh.objd and o.owner not in ('SYS','SYSTEM') and o.owner in ('SCOTT') group by o.object_name order by count(1);
OBJECT_NAME BLOCKS
---------------------------------------- ----------
DEMO 5
TABLE_PARTITION 29
2.查看dept表。
SYS@ oracle1 as AS SYSDBA>conn scott/tiger
Connected.
SCOTT@ oracle1 as >select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO<