Home » RDBMS Server » Performance Tuning » index monitoring (Oracle 9i windows 2000 server sp4)
index monitoring [message #294184] Wed, 16 January 2008 13:47 Go to next message
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.
Re: index monitoring [message #294185 is a reply to message #294184] Wed, 16 January 2008 13:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: index monitoring [message #294204 is a reply to message #294185] Wed, 16 January 2008 16:41 Go to previous message
agemaia
Messages: 11
Registered: January 2008
Junior Member
I waited and... worked

thanks

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


Current Time: Sat Dec 10 20:18:01 CST 2016

Total time taken to generate the page: 0.12796 seconds