viernes, 29 de mayo de 2020

PL/SQL Cache Packages Procedures Functions

sql>select owner,name,type from v$db_object_cache
where sharable_mem > 100
and owner='SYSADM'
and (type='PACKAGE' or type='PACKAGE BODY' or type='FUNCTION' or type='PROCEDURE')
and kept='NO'

sql>execute dbms_shared_pool.keep('package_name');

No hay comentarios: