How can you tell if an index on particular table is used or not used in 9i?
- 1 Answers
- 637 Views
- I also Faced
- E-Mail Answers
Answer / Rakee Maurya
To determine whether an index on a specific table is being used or not in Oracle 9i, you can use the DBMS_STATS package's DISPLAY_INDEX_USAGE procedure. The syntax is as follows: DBMS_STATS.DISPLAY_INDEX_USAGE(ownname => 'your_schema', indexname => 'your_index'); This will display the last time the index was used, its usage percentage, and other related statistics.
| Is This Answer Correct ? | 0 Yes | 0 No |
List five most important parameter in 9i affecting performance?
What are elements of administration?
Which database is best to learn?
You see multiple fragments in the system tablespace, what should you check first?
What are roles in oracle?
How can you tell if a tablespace has excessive fragmentation?
When configuring sqlnet on the client what files need to be set up?
Is oracle dba in demand?
How many types of dba are there?
How to uncatalog backup?
What is difference between co-related sub query and nested sub query?
How do you set up your tablespace on installation level: low?
Oracle General 
