2021年10月26日
Slow performance fix oracle alert log v$diag_alert_ext x$diag_alert_ext
摘要： v$diag_alert_ext aka x$diag_alert_ext should be useful for querying the oracle alert log. Unfortunately with comon conditions in the where clause, que 阅读全文
posted @ 2021-10-26 14:21 高山流水2021 阅读(297) 评论(0) 推荐(0)
Read the Alert Log From SQL (X$DBGALERTEXT and V$DIAG_ALERT_EXT)
摘要： 参考 https://oracle-base.com/articles/11g/read-alter-log-from-sql This article describes how to read the database alert log from SQL using the X$DBGALER 阅读全文
posted @ 2021-10-26 14:18 高山流水2021 阅读(120) 评论(0) 推荐(0)
insert oracle sql text into mysql table
摘要： WITH c AS (SELECT FORCE_MATCHING_SIGNATURE, COUNT(*) cnt FROM v$sqlarea WHERE FORCE_MATCHING_SIGNATURE!=0 GROUP BY FORCE_MATCHING_SIGNATURE HAVING COU 阅读全文
posted @ 2021-10-26 14:13 高山流水2021 阅读(56) 评论(0) 推荐(0)