Re: Can view$ be pinned ?

  • From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
  • To: frank4oraclel@xxxxxxxx
  • Date: Thu, 2 Dec 2004 15:31:16 +0100

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/
--
//www.freelists.org/webpage/oracle-l

Other related posts: