Question: I want to know the
dictionary script to display all Oracle text indexes that
are defined in my database. What view contains Oracle
text indexes metadata?
Answer: The
ctx_indexes view contains the definitions for all Oracle
text indexes for a database, and the following script can be
used to display all Oracle text indexes for a table:
column
idx_owner heading
'Owner'
format a8
column idx_name
heading 'Index|Name'
format a24;
column idx_table
heading 'Table|Indexed'
format a22
column idx_text_name heading 'Column|Indexed'
format a21
column idx_docid_count heading 'Number|Rows|Indexed'
format 99999
column idx_status
heading 'Index|Status'
format a8
break on idx_owner
select
idx_owner,
idx_name,
idx_table,
idx_text_name,
idx_docid_count,
idx_status
from
ctx_indexes
group by
idx_owner,
idx_name,
idx_table,
idx_text_name,
idx_docid_count,
idx_status
;/
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
