Re: Which packages to pin

From: Thomas Day <tomday2_at_gmail.com>
Date: Wed, 13 Jul 2005 15:28:11 -0400
Message-ID: <a8c50459050713122829c4e6be@mail.gmail.com>

This creates an after startup trigger that will pin SYS owned packages in the shared pool. This is usually sufficient to prevent pool fragmentation, at least in my experience it has been. Of course, your milage may vary. As in all things Oracle - "It depends".

SELECT 'create or replace trigger sys.pin_db_objects' FROM DUAL;
SELECT 'after startup on database' FROM DUAL;
SELECT 'begin' FROM DUAL;

SELECT UNIQUE('sys.dbms_shared_pool.keep('''||OWNER||'.'||NAME||''');')   FROM v$db_object_cache
 WHERE type LIKE 'PACK%' and OWNER LIKE '%SYS%' /
SELECT 'end;' FROM DUAL;
SELECT '/' FROM DUAL;

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 13 2005 - 14:31:13 CDT