如何查看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
---------------------------------------------------------------------------------------------------- ---------- --------------------
SELECT * FROM "LEIN" "LEIN" WHERE "MANDT"=:A0 AND "LENUM"=:A1 FOR UPDATE SAPLL03T
#查看该SQL的绑定变量的值具体
SQL> col VALUE_STRING for A50
SQL> col NAME for A10
SQL> col SQL_ID for A15
SQL> SELECT A.SQL_ID,A.NAME,A.POSITION,A.DATATYPE_STRING,A.VALUE_STRING,LAST_CAPTURED FROM V$SQL_BIND_CAPTURE A WHERE A.SQL_ID IN ('fqyhfw5h5rs5q') ;
SQL_ID NAME POSITION DATATYPE_STRING VALUE_STRING LAST_CAPTURED
--------------------------------------- ---------- ---------- --------------------------------------------- -------------------------------------------------- ---------------
fqyhfw5h5rs5q :A0 CHAR() -APR-
fqyhfw5h5rs5q :A1 CHAR() -APR-
#查看该SQL历史执行计划
SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_AWR(SQL_ID => 'fqyhfw5h5rs5q' )) ; PLAN_TABLE_OUTPUT ------------------------------------------------------------------------- SQL_ID fqyhfw5h5rs5q -------------------- SELECT * FROM "LEIN" "LEIN" WHERE "MANDT"=:A0 AND "LENUM"=:A1 FOR UPDATE Plan hash value: --------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | --------------------------------------------------------------------------------------- | | SELECT STATEMENT | | | | ()| | | | FOR UPDATE | | | | | | | | TABLE ACCESS BY INDEX ROWID| LEIN | | | ()| :: | | | INDEX UNIQUE SCAN | LEIN~ | | | ()| | --------------------------------------------------------------------------------------- rows selected.
#查询DBA_HIST_SQLBIND
SELECT SNAP_ID，SQL_ID,NAME,POSITION,DATATYPE_STRING，VALUE_STRING,LAST_CAPTURED FROM DBA_HIST_SQLBIND WHERE SQL_ID='fqyhfw5h5rs5q'; SQL> SELECT SQL_ID,NAME,POSITION,DATATYPE_STRING,VALUE_STRING,COUNT() FROM DBA_HIST_SQLBIND WHERE SQL_ID='fqyhfw5h5rs5q' AND SNAP_ID BETWEEN AND GROUP BY SQL_ID,NAME,POSITION,DATATYPE_STRING，VALUE_STRING; SQL_ID NAME POSITION DATATYPE_STRING VALUE_STRING COUNT() --------------- ---------- ---------- --------------- -------------------------------------------------- ---------- fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A0 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() rows selected. SQL> SELECT SQL_ID,NAME,DATATYPE_STRING,VALUE_STRING,COUNT() FROM DBA_HIST_SQLBIND WHERE SQL_ID='fqyhfw5h5rs5q' AND SNAP_ID BETWEEN AND GROUP BY SQL_ID,NAME,DATATYPE_STRING，VALUE_STRING; SQL_ID NAME DATATYPE_STRING VALUE_STRING COUNT() --------------- ---------- --------------- -------------------------------------------------- ---------- fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A0 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() fqyhfw5h5rs5q :A1 CHAR() rows selected.
以上就是[ORACLE]查看SQL绑定变量具体值 查看SQL绑定变量值的详细内容，更多关于[ORACLE]查看SQL绑定变量具体值 查看SQL绑定变量值的资料请关注九品源码其它相关文章！