Not quite. A get is an attempt to locate an object in the library cache. If it is not found, it is loaded. Database object definitions are loaded from the data dictionary via the dictionary cache. Cursors are loaded by parsing the statement text.

A pin is an attempt to use a previously located object in the library cache. If it has been aged out, then it must be reloaded.

Can someone please give me a clear definition of the following terms as they apply to the Library cache, as I'm a little confused. From various sources I have arrived at the following definitions.

GETS - the total number of SQL requests sent to the database
PINS - the number of times requested SQL was found in memory (effectively the number hits?)
RELOADS - total number of times requested SQL was not found inmemory requiring hard parse (effectively the number of misses?)

Is my interpretation correct?