Re: What is an Oracle pin?

From: <rspeaker_at_my-dejanews.com>
Date: Mon, 11 Jan 1999 18:07:00 GMT
Message-ID: <77dek1$vot$1@nnrp1.dejanews.com>

A 'pin' could typically have several meanings to Oracle. A 'pinned' statement or package is one that is found in shared memory when it is executed. This avoids reparsing of the statement and increases performance. A 'pinned' buffer in the buffer cache is a buffer that is in the process of being changed and cannot be written to disk during the current DBWR execution.

HTH,
Roy

In article <369a02f6.3336668_at_news.tcp.co.uk>, aspscott_at_tcp.co.uk (Paul) wrote:
> What is an Oracle pin?
>
> Paul
> aspscott_at_tcp.co.uk
> ^^ remove 'as' anti spam prefix to reply
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 11 1999 - 12:07:00 CST