Introdução 

 SQL Scripts 

 Packages 

 Packages Body 
 pkg_nkw_exc 
 pkg_nkw_rpl 
 pkg_nkw_std 
 pkg_nkw_app 
 pkg_nkw_spm 
 pkg_nkw_hfs 
 pkg_nkw_sdv 
 pkg_nkw_sys 
 pkg_nkw_obj 
 pkg_nkw_grv 
 pkg_nkw_usr 
 pkg_nkw_cmm 
 pkg_nkw_hlp 
 pkg_nkw_dvp 
 pkg_nkw_dnt_std 
 pkg_nkw_dnt_dvies 
 pkg_nkw_dnt_ccvies 
 pkg_nkw_dnt_logies 
 pkg_nkw_dnt_eppc 
 pkg_nkw_dnt_eapb 
 pkg_nkw_dnt_drmies 
 pkg_nkw_dnt 
 pkg_nkw_drm 
 pkg_nkw_oim 
 pkg_nkw_aud 
 pkg_nkw_dpl 
 pkg_nkw_srw 

 Forms 6i 

 Reports 6i 

Linux

 Downloads 
PKG_NKW_SPM.SPB
Source Package Body
Gerenciamento da Shared Pool.
create or replace package body pkg_nkw_spm
timestamp '2006-07-07:10:10:10'
is
   ------------------------------------------------------------------
   -- 2006 DataPRO Developers - m@urelio
   ------------------------------------------------------------------
   -- Version: 2.0.2
   ------------------------------------------------------------------
   -- Collections, Records, Variables, Constants, Exceptions, Cursors
   ------------------------------------------------------------------
   ------------------------------------------------------------------
   ----------------------- Private Section --------------------------
   ------------------------------------------------------------------
   ------------------------------------------------------------------
   ------------------------ Public Section --------------------------
   ------------------------------------------------------------------
   ------------------------------------------------------------------
   -- KEEP
   ------------------------------------------------------------------
   procedure keep
   is
   begin
      dbms_shared_pool.keep('sys.standard');
      dbms_shared_pool.keep('sys.dbms_sql');
      dbms_shared_pool.keep('nk.pkg_nkw_env');
      dbms_shared_pool.keep('nk.pkg_nkw_app');
      dbms_shared_pool.keep('nk.pkg_nkw_aud');
      dbms_shared_pool.keep('nk.pkg_nkw_hlp');
      dbms_shared_pool.keep('nk.pkg_nkw_hfs');
      dbms_shared_pool.keep('nk.pkg_nkw_sys');
      dbms_shared_pool.keep('nk.pkg_nkw_obj');
      dbms_shared_pool.keep('nk.pkg_nkw_oim');
      dbms_shared_pool.keep('nk.pkg_nkw_rpl');
      dbms_shared_pool.keep('nk.pkg_nkw_sdv');
      dbms_shared_pool.keep('nk.pkg_nkw_std');
      dbms_shared_pool.keep('nk.pkg_nkw_drm');
      dbms_shared_pool.keep('nk.pkg_nkw_srw');
      dbms_shared_pool.keep('nk.pkg_nkw_usr');
      dbms_shared_pool.keep('nk.pkg_nkw_dnt');
      dbms_shared_pool.keep('nk.pkg_nkw_dnt_ccvies');
      dbms_shared_pool.keep('nk.pkg_nkw_dnt_dvies');
      dbms_shared_pool.keep('nk.pkg_nkw_dnt_drmies');
      dbms_shared_pool.keep('nk.pkg_nkw_dnt_logies');
      dbms_shared_pool.keep('nk.pkg_nkw_dnt_eppc');
      dbms_shared_pool.keep('nk.pkg_nkw_dnt_eapb');
      dbms_shared_pool.keep('nk.pkg_nkp_app');
      dbms_shared_pool.keep('nk.pkg_nkp_hlp');
      dbms_shared_pool.keep('nk.pkg_nkp_obj');
      dbms_shared_pool.keep('nk.pkg_nkp_drm');
      dbms_shared_pool.keep('nk.pkg_nkp_frm');
      dbms_shared_pool.keep('nk.pkg_nkp_srw');
      dbms_shared_pool.keep('nk.pkg_nkp_std');
      exception
	 when others then raise;
   end keep;
end pkg_nkw_spm;
© 2017 DataPRO Developers