摘要： 如何查看SQL的绑定变量的值 #查看SQL语句 SQL> SELECT A.SQL_TEXT,A.EXECUTIONS,A.MODULE FROM V$SQL A WHERE A.SQL_ID IN ('fqyhfw5h5rs5q'); SQL_TEXT EXECUTIONS MODULE SELE 阅读全文

摘要： 检查系统发现锁 enq: TX - allocate ITL entry SQL> SELECT DISTINCT D.CURRENT_OBJ#,D.INSTANCE_NUMBER,D.SESSION_ID,D.SESSION_SERIAL#,D.BLOCKING_SESSION,D.BLOCKIN 阅读全文

摘要： ASH 报表显示 enq: TX - allocate ITL entry SQL> SELECT D.SQL_ID, COUNT(1) FROM DBA_HIST_ACTIVE_SESS_HISTORY D WHERE D.SAMPLE_TIME BETWEEN TO_DATE('2020-04- 阅读全文