control file sequential read

最新推荐文章于 2021-05-19 11:55:26 发布

amto001

最新推荐文章于 2021-05-19 11:55:26 发布

阅读量728

点赞数

分类专栏： Oracle性能问题分析

本文链接：https://blog.youkuaiyun.com/amto001/article/details/9451631

版权

1 篇文章

订阅专栏

本文介绍了数据库中控制文件的顺序读取过程，包括备份控制文件、实例间信息共享及从控制文件读取其他块等内容。文章详细解释了读取过程中涉及的参数，如等待时间、文件号、起始读取的块号以及尝试读取的块数量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Reading from the control file. This happens in many cases. For example, while:

Wait Time: The wait time is the elapsed time of the read

Parameter	Description
file#	The control file from which the session is reading
block#	Block number in the control file from where the session starts to read. The block size is the physical block size of the port (usually 512 bytes, some UNIX ports have 1 or 2 Kilobytes).
blocks	The number of blocks that the session is trying to read