| |
GeekInterview.com > Interview Questions > Oracle > Scenarios
| Print | |
Question: Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.
|
| March 03, 2007 18:49:02 |
#5 |
| Chiranjeevi Manne |
Member Since: Visitor Total Comments: N/A |
RE: Very next day on the prodction box It looks some p...
|
| The best way to check for the number of invalid objects is using the "UTLRP.SQL" which compiles all the objects source code and lists the number of invalid objects. One after getting the number of invalid objects query v$BH table to get the name of all the invalid objects |
| |
Back To Question | |
