Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!arclight.uoregon.edu!logbridge.uoregon.edu!news-feed.riddles.org.uk!sn-xit-03!sn-xit-06!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: v$librarycache -- sorry for crossposting
Date: Mon, 03 Mar 2003 21:32:37 -0800
Organization: EXE
Message-ID: <3E643A75.52FF09C@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
References: <8iW8a.352689$Ec4.353541@rwcrnsc52.ops.asp.att.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@splish28.drizzle.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 17
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178350
X-Received-Date: Mon, 03 Mar 2003 22:33:04 MST (news.easynews.com)



aNotherDBA wrote:

> Does anyone have a better explanation of the GETS and PINS columns in this
> view, besides:
>
> GETS: Handle requests for objects of this namespace
> PINS: PIN requests for objects of this namespace
>
> Are the GETS necessarily physical gets???  Can they be physical GETS (from
> the disk)?  I'm struggling with this concept somewhat.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch392.htm#1116696

Daniel Morgan

