How to obtain the variable value bound to an OracleSQL statement

When diagnosing SQL Performance problems, we sometimes need to obtain the actual value of the variable bound to it, and then bring the actual value into the SQL statement, using the original SQL to form the select statement (

When diagnosing SQL Performance problems, we sometimes need to obtain the actual value of the variable bound to it, and then bring the actual value into the SQL statement, using the original SQL to form the select statement (

When diagnosing SQL Performance problems, we sometimes need to obtain the actual value of the variable it binds, and then bring the actual value into the SQL statement, use the original SQL statement to form a select statement (with the where condition). Execute the statement and check the selectivity.

This document describes how to obtain the bound variable value. Thanks for the help of elders who have prepared this article.

This article applies to databases with Oracle 10 Gb or later.

Alter session set nls_date_format = 'yyyy-mm-dd, hh24: mi: ss ';

Set linesize 400

Col SQL _Id format a20

Col name format a20

Col datatype_string format a14

Col value_string format a20

-- This SQL statement reads the bound variable value information from the memory. If it is not in the memory, the next SQL statement is used.

Select SQL _id, name, datatype_string, last_captured, value_string from v $ SQL _bind_capture where SQL _id = 'dxfcacn4t4ppw' order by LAST_CAPTURED, POSITION;

-- This SQL statement reads the bound variable value information from awr.

Select instance_number, SQL _id, name, datatype_string, last_captured, value_string from dba_hist_sqlbind where SQL _id = 'fahv8x6ngrb50 'order by LAST_CAPTURED, POSITION;

--------------------------------------------------------------------------------

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

--------------------------------------------------------------------------------