| Index usage [message #50322] |
Mon, 11 March 2002 10:13  |
Jose Antonio Soares
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
How can I know what indexes are being used on my database in a given time period?
I need to drop unused indexes, if they exists, because I'm running low on disk availability.
Thanks for any help.
|
|
|
|
| Re: Index usage [message #50330 is a reply to message #50322] |
Mon, 11 March 2002 13:01  |
Wei Lang
Messages: 23
Registered: March 2002
|
Junior Member |
|
|
Oracle9i has V$ view called something like used_objects and you can find the used indexes there.
For Oracle8i, it is difficult. You can use logminer (or V$sqltext, v$sqlarea) to get all sql statenment and do explain plan on them. Write a package and run them every week.
I do not have the working code here. Just an idea.
Sorry can not be more helpful.
Wei
|
|
|
|
| Re: Index usage [message #50340 is a reply to message #50322] |
Tue, 12 March 2002 01:54 |
Jose Antonio Soares
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
I'm so sorry. Forgot to mention my production version:
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
----------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
