Script to Check Object Status In Oracle

The below script can be used to checkĀ  object status in oracle database , usually performed before and after the upgrade.


SQL> select owner,object_type,count(*) from dba_objects group by owner,object_type;


[adrotate group=”1″]


Run this command before and after upgrade . Compare the results to check if any objects became invalid after the upgrade.



Hope this helps .

Wysheid Team

Leave a comment

Your email address will not be published. Required fields are marked *

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve