OraFAQ Forum: Server Administration » how can I detect not used indexes in 8.1.7

Home » RDBMS Server » Server Administration » how can I detect not used indexes in 8.1.7

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can I detect not used indexes in 8.1.7 [message #53128]

Wed, 28 August 2002 13:33

Eugene
Messages: 44
Registered: August 2001

Member

Hi,
I'd like to find all unused indexes. Is there a view in Oracle which will let me do so? I am using 8.1.7

Report message to a moderator

Re: how can I detect not used indexes in 8.1.7 [message #53129 is a reply to message #53128]

Wed, 28 August 2002 14:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

with 9i you can use V$OBJECT_USAGE to monitor unused indexes.
with 8i, u need to write..some stuff....
let me grab some time...!

Report message to a moderator

Re: how can I detect not used indexes in 8.1.7 [message #53131 is a reply to message #53128]

Wed, 28 August 2002 16:38

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

There is no such view in 8i. It 9i yes.

So far I have seen only script for monitoring index storage usage Here but not for the index usage by itself. Oracle realized that and came up with a new column in their dd views.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

The latest Oracle DBA forums

Report message to a moderator

Re: how can I detect not used indexes in 8.1.7 [message #53133 is a reply to message #53129]

Wed, 28 August 2002 16:43

P
Messages: 29
Registered: May 2002

Junior Member

Pretty hard to do, if you suspect an index is not being used you could always put it in its own tablespace. Then all you have to do is monitor how much activity that tablespace has... Slow process, but it's not like you want to be a cowboy when removing indexes anyway.

Report message to a moderator

Previous Topic:	Sending a mail from PL/SQL procedures!!!!!urgent
Next Topic:	Installation of Oracle8i on Hp ux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:54:54 CDT 2024