pinned objects

From: Li, Xiangli <Xiangli.Li_at_aig.com>
Date: Tue, 31 Jul 2001 07:46:57 -0700
Message-ID: <F001.0035A081.20010731065532@fatcity.com>

Hi, all
I kept packages in shared pool, try to reduce number of parses for main packages. But I still found many parse counts in trace file as following.
(Status for package ModelCache in v$db_object_cache is 'YES', and db is
8.0.5 on NT4.0)
BEGIN
ModelCache.RemoveModelData(INCASENO => :001); END; call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------

---

Parse 41 0.34 0.78 0 0 0 0
Execute 41 0.52 1.06 0 0 41 41
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ----------

---

total 82 0.86 1.84 0 0 41 41

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 21

Could anyone explain to me why ?

thanks&regards,
Li

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Li, Xiangli
  INET: Xiangli.Li_at_aig.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 Tue Jul 31 2001 - 09:46:57 CDT