摘要： 建一个触发器，当数据库启动后，触发dbms_shared_pool.keep()的执行创建该存储过程SQL>@...\dbmspool.sql查看该包是否创建SQL>desc dbms_shared_pool创建触发器SQL>conn hr/hr;SQL>CREATE OR REPLACE TRIGGER "HR".HR_START_TR AFTER STARTUP ON DATABASE begin sys.DBMS_SHARED_POOL.KEEP('HR.ADD_JOB_HISTORY'); end;授权给HRgrant exe 阅读全文