幸运飞艇停吗

ASP源碼.NET源碼PHP源碼JSP源碼JAVA源碼DELPHI源碼PB源碼VC源碼VB源碼Android源碼
當前位置:首頁 >> 數據庫 >> 其他數據庫 >> 查看占用CPU資源很高的Oracle進程究竟是在做什么操作,使用如下SQL語句

查看占用CPU資源很高的Oracle進程究竟是在做什么操作,使用如下SQL語句

來源:網絡整理     時間:2018-10-11     關鍵詞:

BENPIANWENZHANGZHUYAOJIESHAOLE" CHAKANZHANYONGCPUZIYUANHENGAODEOracleJINCHENGJIUJINGSHIZAIZUOSHENMECAOZUO,SHIYONGRUXIASQLYUJU",ZHUYAOSHEJIDAOFANGMIANDENEIRONG,DUIYUQITASHUJUKUGANXINGQUDETONGXUEKEYICANKAOYIXIA: select sql_text,spid,v$session.program,process fromv$sqlarea,v$session,v$proces...

select sql_text,spid,v$session.program,process  from



v$sqlarea,v$session,v$process



where v$sqlarea.address=v$session.sql_address



and v$sqlarea.hash_value=v$session.sql_hash_value



and v$session.paddr=v$process.addr



and v$process.spid in (26377,26379,26383,26385,26381,26391);


 查看占用CPU資源很高的Oracle進程究竟是在做什么操作,使用如下SQL語句

幸运飞艇停吗 YISHANGJIUJIESHAOLE CHAKANZHANYONGCPUZIYUANHENGAODEOracleJINCHENGJIUJINGSHIZAIZUOSHENMECAOZUO,SHIYONGRUXIASQLYUJU,BAOKUOLEFANGMIANDENEIRONG,XIWANGDUIQITASHUJUKUYOUXINGQUDEPENGYOUYOUSUOBANGZHU。

BENWENWANGZHILIANJIE:http://snifly.cn/article/detail_4592663.html

相關圖片

相關文章