Answer Detail: RE: 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 va

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.

May 05, 2009 15:31:43	#7
vaddapalli	Member Since: May 2009 Total Comments: 1
RE: 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 va
we can use the @?/rdbms/admin/utlrp.sql The below listed are the scripts that were executed to valid the DBMS_STAT on particular databses. @?/rdbms/admin/dbmsstat.sql @?/rdbms/admin/prvtstas.plb @?/rdbms/admin/prvtstat.plb

Back To Question