本文介绍获取sql语句中绑定变量的值,以利于分析sql性能
当前数据库版本
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
主要使用V$SQL_BIND_CAPTURE 和 v$SQLTEXT
V$SQL_BIND_CAPTURE displays information on bind variables used by SQL cursors. Each row in the view contains information for one bind variable defined in a cursor
SELECT B.SQL_TEXT,A.SQL_ID,NAME, DATATYPE_STRING, LAST_CAPTURED,VALUE_STRING FROM V$SQL_BIND_CAPTURE A,V$SQLTEXT B WHERE A.SQL_ID=B.SQL_ID AND A.SQL_ID='0b6gu4vscc02s'
本文乃原创文章,请勿转载。如须转载请详细标明转载出处