SQL Script Tables accessed Recently By Full Scan

Updated: 14-Mar-2002
Version: 1.0

Description

Lists tables that have been recently accessed by a full table scan. This script must be run as SYS.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set serverout on size 1000000
set verify off

col object_name form a30

PROMPT lists tables that have been recently accessed by a full table scan
PROMPT Column flag in x$bh table is set to value 0x80000, when
PROMPT block was read by a sequential scan. 

spool bufferts.lst

SELECT o.object_name,o.object_type,o.owner
FROM dba_objects o,x$bh x
WHERE x.obj=o.object_id
AND o.object_type='TABLE' 
AND standard.bitand(x.flag,524288)>0 
AND o.owner<>'SYS';

spool off

Related Links

Oracle 9i: (SQL Script) Objects in DB Cache

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links