Home » RDBMS Server » Server Administration » monitoring unusable objects
monitoring unusable objects [message #553513] Sun, 06 May 2012 01:34 Go to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
how monitor the unusable objects in oracle 10g (10.2.0.1.0) os rhel 5?
is it same as invalid objects and can be monitor as same?

regards
pritesh ranjan

Report message to a moderator

Re: monitoring unusable objects [message #553516 is a reply to message #553513] Sun, 06 May 2012 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe using SELECT on DBA_OBJECTS or DBA_INDEXES family depending on what you actually mean.

Regards
Michel

Report message to a moderator

Re: monitoring unusable objects [message #553537 is a reply to message #553516] Sun, 06 May 2012 10:26 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
no any other mean only want to monitor the unusable objects.

Report message to a moderator

Re: monitoring unusable objects [message #553539 is a reply to message #553537] Sun, 06 May 2012 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>no any other mean only want to monitor the unusable objects.
wait for error to be thrown.

What is wrong with querying the Data Dictionary where these details reside?

Report message to a moderator

Re: monitoring unusable objects [message #553543 is a reply to message #553539] Sun, 06 May 2012 11:38 Go to previous message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
nothing wrong. just conform it.

Report message to a moderator

Previous Topic: system tablespace had been used more.
Next Topic: When to gather table statistics
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 02:26:29 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.