Oracle-L: Multiple loads for a kept package?

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Wed, 22 May 2002 11:58:33 -0800
Message-ID: <F001.00468366.20020522115833@fatcity.com>

Hey all,

On 8.1.6.0.0 on Solaris, I've got a trigger on startup to keep the SYS.DBMS_OUTPUT and SYS.DBMS_APPLICATION_INFO packages (among other procs) via DBMS_SHARED_POOL.KEEP. When I look at them in V$DB_OBJ_CACHE, "LOADS" for each is "10".

This has me a little confused. Can anyone explain why loads would be > 1? BUG 1164709 on MetaLink references this but it's a little vague.

TIA,

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 22 2002 - 14:58:33 CDT