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.
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· .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 中如何实现缓存的预热?