随笔 - 225  文章 - 0  评论 - 6  阅读 - 75098

oracle event 'disk file operations i/o'

Disk file operations I/O This event is used to wait for disk file operations (for example, open, close, seek, and resize). It is also used for miscellaneous I/O operations such as block dumps and password file accesses.

Wait Time: The wait time is the actual time it takes to do the I/O Parameter Description FileOperation Type of file operation fileno File identification number filetype Type of file (for example, log file, data file, and so on)

today, the event 'disk file operations i/o' cost 0.45s, so i pay attention to it.

if we look into 10046 trace file.it show as follow: __________________________________________________________________________________________________

WAIT #406867792: nam='Disk file operations I/O' ela= 244361 FileOperation=2 fileno=4 filetype=2 obj#=485041 tim=469151246210

.....

WAIT #406867792: nam='Disk file operations I/O' ela= 91489 FileOperation=2 fileno=5 filetype=2 obj#=485683 tim=469151708966

WAIT #406867792: nam='db file scattered read' ela= 5876 file#=5 block#=609704 blocks=8 obj#=485683 tim=469151714974

WAIT #406867792: nam='Disk file operations I/O' ela= 54923 FileOperation=2 fileno=7 filetype=2 obj#=485683 tim=469151770139 ..... __________________________________________________________________________________________________

select * from DBA_DATA_FILES where file_id in (4,5,7); see whick file

select * from dba_objects where object_id IN (485683,485041); see which object

after check, it seems mean creating i/o handle for oracle reading specifically file.

posted on   子虚乌有  阅读(2606)  评论(0编辑  收藏  举报
编辑推荐:
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
阅读排行:
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 三行代码完成国际化适配,妙~啊~
· .NET Core 中如何实现缓存的预热?
< 2013年3月 >
24 25 26 27 28 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

点击右上角即可分享
微信分享提示