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;
|