关于Oracle数据库Kfk: Async Disk IO等待事件深度解析
发布时间：2025-11-05 07:44:56 来源：创站工坊 作者：IT科技
复制SELECT inst_id,关于EVENT, SUM(DECODE(WAIT_TIME, 0, 0, 1)) "Prev", SUM(DECODE(WAIT_TIME, 0, 1, 0)) "Curr", COUNT(*) "Tot" , sum(SECONDS_IN_WAIT) SECONDS_IN_WAIT FROM GV$SESSION_WAIT WHERE event NOT IN (smon timer,pmon timer,rdbms ipc message,SQL*Net message from client,gcs remote message) AND event NOTLIKE%idle% AND event NOTLIKE%Idle% AND event NOTLIKE%Streams AQ% GROUPBY inst_id,EVENT ORDERBY 1,5 desc; --class slave wait 1.2.3.4.5.6.7.8.9.10.11.
服务器租用源码下载企商汇源码库香港云服务器亿华云IT技术网益华科技IT资讯网亿华智造益华IT技术论坛技术快报益华科技亿华灵动亿华互联创站工坊码上建站益强数据堂智能时代全栈开发极客编程思维库IT资讯网亿华科技亿华云计算编程之道云智核益强科技益强资讯优选益强IT技术网码力社益强前沿资讯运维纵横益强智囊团极客码头科技前瞻益华科技益强智未来益强科技亿华智慧云汇智坊益强编程舍云站无忧
- Copyright © 2025 Powered by 关于Oracle数据库Kfk: Async Disk IO等待事件深度解析,创站工坊 滇ICP备2023006006号-44sitemap