Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the bind variables for a given sql_id

Rajan SwFeb 7 2019 — edited Feb 8 2019

Hi,

In AWR report, I can check one sql as below and its sql_id is 1uquqxwf8ry5v.

is there any way to find the real values substituted for these bind vairables during execution.

if I query v$sql_bind_capture for this sql_id not getting any data

INSERT INTO ic123.lz_item_errors VALUES('TellerAPI', :P0, :P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11)

Please help me on this.

The current DB version is : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Comments
Post Details
Added on Feb 7 2019
12 comments
12,754 views