From: 76434.1353@compuserve.com
Newsgroups: comp.databases.oracle.server
Subject: Library Caches Reports
Date: Mon, 09 Sep 2002 18:03:55 GMT
Organization: Hobby Computer Club News Network
Lines: 5
Message-ID: <3d7ce17f.1688808@news.hccnet.nl>
NNTP-Posting-Host: fia99-10.dsl.hccnet.nl
X-Trace: news.hccnet.nl 1031594482 19807 62.251.10.99 (9 Sep 2002 18:01:22 GMT)
X-Complaints-To: abuse@hccnet.nl
NNTP-Posting-Date: Mon, 9 Sep 2002 18:01:22 +0000 (UTC)
X-Newsreader: Forte Free Agent 1.21/32.243


I runnewd a script to report the library cashes: 

Result was for the SQL AREA.   High % Get hits and  High % Pin hits.
But many Reloads and Invalidations. Where are the reloads and
validations coming from? And how can i decrease their numbers?