SQL Script Recently Accessed Indexes

Updated: 14-Mar-2002
Version: 1.0

Description

When maintaining the database, it is sometimes useful to know which indexes were most recently accessed by users.

Parameters

None

SQL Source

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

set serverout on size 1000000
set verify off

column owner format a20 trunc
column segment_name format a30 trunc

PROMPT When maintaining the database, it is sometimes useful to know which 
PROMPT indexes were most recently accessed by users.

spool bufferidx.lst

select distinct b.owner, b.segment_name
from x$bh a, dba_extents b         
where b.file_id=a.dbarfil 
and a.dbablk between b.block_id 
and b.block_id+blocks-1 
and segment_type='INDEX' and  b.owner not in ('SYS','SYSTEM')
/

spool off

Related Links

Oracle 10g: (SQL Script) DB Block Buffer

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