baggiiiie

dbms-buffer-pool-pin

What does it mean when a page in a buffer pool has pins on it?

tags: learning database

content

  • a pin indicates this page is currently being accessed
    • some transactions or processes are using this page
  • the page is pinned so that it will not be evicted by buffer pool manager due to page eviction

up

down

reference

Graph View