[置顶] by session_wait get session waitting event;
摘要： select sid,event,p1,p1text from v$session_wait; 阅读全文
posted @ 2022-10-31 16:13 jack5201981 阅读(16) 评论(0) 推荐(0)
2022年10月31日
get oracle_text by sql
摘要： SELECT sql_text FROM v$sqltext a WHERE a.hash_value = (SELECT sql_hash_value FROM v$session b WHERE b.SID = '&sid') ORDER BY piece ASC / 阅读全文
posted @ 2022-10-31 16:10 jack5201981 阅读(21) 评论(0) 推荐(0)