OraFAQ Forum: Performance Tuning » index monitoring

Home » RDBMS Server » Performance Tuning » index monitoring (Oracle 9i windows 2000 server sp4)

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

index monitoring [message #294184]

Wed, 16 January 2008 13:47

agemaia
Messages: 11
Registered: January 2008

Junior Member

hi,

trying to monitor my indexes in order to know if they are used:

alter index indexname monitoring usage;

indexes in my schema but the result is

ORA-00054: resource busy and acquire with NOWAIT specified

should I restart the database and not allow users to connect?

thanks.

Report message to a moderator

Re: index monitoring [message #294185 is a reply to message #294184]

Wed, 16 January 2008 13:53

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You just have to be sure than nobody else is modifying the index or index data. Try to lock the table before.

Regards
Michel

Report message to a moderator

Re: index monitoring [message #294204 is a reply to message #294185]

Wed, 16 January 2008 16:41

agemaia
Messages: 11
Registered: January 2008

Junior Member

I waited and... worked

thanks

Report message to a moderator

Previous Topic:	Update only 8 rows in a huge Table
Next Topic:	last queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 00:52:03 CST 2025