Re: Can view$ be pinned ?

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Thu, 2 Dec 2004 15:31:16 +0100
Message-ID: <3b0f44a1041202063111fe3ef9@mail.gmail.com>

Frank:

The dictionary cache management is completely different from the buffer cache. In buffer cache, data blocks are cached and in the dictionary cache the relative rows are cached. That is why we call the dictionary cache as row cache. And the rows are protected by the row cache enqueues. So pinning may not be possible..

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 02 2004 - 08:28:39 CST