expdp导出慢,看等待事件是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)
这种问题就是存储慢的问题,硬件层面上的问题。
博客内容涉及数据库导出操作expdp出现速度缓慢的问题,主要等待事件为DiskfileoperationsI/O,这通常指示硬盘I/O性能问题。文章详细解释了该等待事件,包括实际I/O时间、文件操作类型和文件标识等参数,并指出此问题根源在于硬件层面的存储速度。

被折叠的 条评论
为什么被折叠?



