27 lines
880 B
SQL
27 lines
880 B
SQL
-- -----------------------------------------------------------------------------------
|
|
-- File Name : https://oracle-base.com/dba/19c/auto_indexes.sql
|
|
-- Author : Tim Hall
|
|
-- Description : Displays auto indexes for the specified schema or all schemas.
|
|
-- Requirements : Access to the DBA views.
|
|
-- Call Syntax : @auto_indexes (schema-name or all)
|
|
-- Last Modified: 04/06/2019
|
|
-- -----------------------------------------------------------------------------------
|
|
SET VERIFY OFF LINESIZE 200
|
|
|
|
COLUMN owner FORMAT A30
|
|
COLUMN index_name FORMAT A30
|
|
COLUMN table_owner FORMAT A30
|
|
COLUMN table_name FORMAT A30
|
|
|
|
SELECT owner,
|
|
index_name,
|
|
index_type,
|
|
table_owner,
|
|
table_name
|
|
table_type
|
|
FROM dba_indexes
|
|
WHERE owner = DECODE(UPPER('&1'), 'ALL', owner, UPPER('&1'))
|
|
AND auto = 'YES'
|
|
ORDER BY owner, index_name;
|
|
|