catalog.sql and catproc.sql are used to create/recreate database internal views/procedures/packages, etc...
They are primarily used after applying a patch/patchset to the database (Refer to instructions of your specific patch/patchset)
Pros:
It is not harmful to run these against a database.
Cons:
It will consume resources when running.




Reply With Quote