📜 ⬆️ ⬇️

Fast compilation of a large number of invalid objects in the database

The database is in restricted (startup startup is performed or alter sytem enable restricted session + all user sessions are killed).
listener stopped.

Sequencing.



Recompilation of a large number of objects may be required after upgrades of the oracle software or the applied part of the software in the database.
In this case, the usual instructions contain recommendations to run utlrp in the normal DB mode, but in reality there are problems when the jobs and user sessions are started in the database, and the objects are not yet compiled.
If you run utlrp in restricted, it will not work in parallel. If you remove the listener, disable the jobs, and exit the restricted before running utlrp, then the parallel will not work again, because of the disabled jobs.
The above sequence, however, works because utlrp is not started under restricted and creates its own Jobs with allow_rusn_in_restricted_mode attributes — they will start after entering the appropriate commands in another session.
')
Actually for a DB with a large number of objects and tasks in dba_jobs, dba_scheduler_jobs.

Source: https://habr.com/ru/post/199088/


All Articles