BUFFER IS PINNED COUNT
PavelMar 2 2012 — edited Mar 7 2012Hello !
Could I ask You to explain about BUFFER IS PINNED COUNT please ?
http://dbaspot.com/oracle-server/156378-definition-buffer-pinned-count.html
http://www.freelists.org/archives/or.../msg00697.html
"Buffer is pinned count: -
Oracle has previously pinned a buffer, and
not released it immediately. A pin may be
held for the duration of a database call.
Oracle can revisit the buffer by traversing
the pin without acquiring the latch, because
the presence of the pin ensures that no other
session could have acquired that buffer in a
conflicting fashion."
Can You explain in other words please ?
Is it possible visit without latch ?
Thanks and regards,
Pavel
Edited by: Pavel on Mar 1, 2012 11:24 PM