Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BUFFER IS PINNED COUNT

PavelMar 2 2012 — edited Mar 7 2012

Hello !

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

This post has been answered by Aman.... on Mar 2 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2012

Added on Mar 2 2012

#general-database-discussions

21 comments

3,741 views