Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2012
Added on Mar 2 2012
21 comments
3,741 views