OeBS : Инвалидные объекты

Немного скриптов для перекомпиляции инвалидных объектов

-- Remember to connect as SYSDBA!
CONNECT SYS / AS SYSDBA;
-- Recompile all objects serially
EXEC UTL_RECOMP.RECOMP_SERIAL();
-- Recompile all objects owned by HR serially
EXEC UTL_RECOMP.RECOMP_SERIAL('HR');
-- Recompile all objects using a specified number of CPU threads
EXEC UTL_RECOMP.RECOMP_PARALLEL(4);
-- Recompile all objects in the SH schema, but let Oracle use all
-- threads specified in JOB_QUEUE_PROCESSES
EXEC UTL_RECOMP.RECOMP_PARALLEL(NULL, 'SH');
EXEC UTL_RECOMP.RECOMP_PARALLEL(4);

-- Колличество инвалидов
select count (*)
from all_objects
where status<> 'VALID'
and (object_name like 'XXT%' or object_name like 'XLA%')
and object_name not like '%MGR%'