Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PINS Vs. GETS

PINS Vs. GETS

From: Scott McLeod <scottrmcleod_at_mn.mediaone.net>
Date: 2000/05/16
Message-ID: <qocU4.100$vY.7077@news7.onvoy.net>#1/1

Can someone explain to me why, when viewing V$LIBRARYCACHE the pins would behigher than gets. My understanding was that gets are for each lookup and pins represent each execution. Wouldn't each execution have to be preceeded by a lookup? If that were the case I expected gets to be high than pins. But in my snapshot, pins are twice gets. Received on Tue May 16 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US