quinta-feira, 28 de novembro de 2013

Fixar Packages na Shared Pool (SQL Area)


 Devido ao seu uso constante  eu recomendo que os
 packages abaixo  estejam  fixados na  Shared Pool.
 Exemplo de roteiro para ser disparado no Startup:
  
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_SHARED_POOL');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_ALERT');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_DDL');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_DESCRIBE');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_LOCK');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_OUTPUT');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_PIPE');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_SESSION');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_STANDARD');
 EXECUTE DBMS_SHARED_POOL.KEEP('DBMS_UTILITY');
 EXECUTE DBMS_SHARED_POOL.KEEP('STANDARD')

Nenhum comentário:

Postar um comentário