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
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: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe using SELECT on DBA_OBJECTS or DBA_INDEXES family depending on what you actually mean.

Regards
Michel
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.
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?
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.
Previous Topic: system tablespace had been used more.
Next Topic: When to gather table statistics
Goto Forum:
  


Current Time: Thu Mar 28 08:08:38 CDT 2024