本文介绍了数据库缓存中固定（pinned）缓冲区的概念及其作用。当用户会话正在访问某个缓冲区时，该缓冲区会被标记为固定状态以防止其从内存中老化淘汰。同一时间内，多个会话不能同时修改同一个被固定的缓冲区。
12. Which is the correct description of a pinned buffer in the database buffer cache?
A.The buffer is currently being accessed.
B.The buffer is empty and has not been used.
C.The contents of the buffer have changed and must be flushed to the disk by the DBWn process.
D.The buffer is a candidate for immediate aging out and its contents are synchronized with the block
contents on the disk.
Answer: A
答案解析：
Every buffer has an access mode:
pinnedor
free(unpinned). A buffer is "pinned" in the cache so that it does not age out of memory while a user session accesses it. Multiple sessions cannot modify a pinned buffer at the same time.
扫一扫
5919
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
