Logo

SQL Script

Tables Accessed Recently By Full Scan

 Tested on Oracle 8.1

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

set serverout on size 1000000
set verify off

col object_name form a30

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

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz
Legal

Logo