<<Back to PT Main Page
Finding the Bind Variable Value for a Given SQLID in Oracle
COLUMN sql_text FORMAT A120
COLUMN sql_id FORMAT A13
COLUMN bind_name FORMAT A10
COLUMN bind_value FORMAT A26
SELECT
sql_id,
t.sql_text sql_text,
b.name bind_name,
b.value_string bind_value,
b.LAST_CAPTURED
FROM
v$sql t
JOIN
v$sql_bind_capture b using (sql_id)
WHERE
b.value_string is not null
AND
sql_id='&sqlid'
/
Finding the Historical Bind Variable Value for a Given SQLID in Oracle
COLUMN sql_text FORMAT A120
COLUMN sql_id FORMAT A13
COLUMN bind_name FORMAT A10
COLUMN bind_value FORMAT A26
SELECT
sql_id,
t.sql_text sql_text,
b.name bind_name,
b.value_string bind_value,
COLUMN sql_id FORMAT A13
COLUMN bind_name FORMAT A10
COLUMN bind_value FORMAT A26
SELECT
sql_id,
t.sql_text sql_text,
b.name bind_name,
b.value_string bind_value,
b.LAST_CAPTURED
FROM
v$sql t
JOIN
DBA_HIST_SQLBIND b using (sql_id)
WHERE
b.value_string is not null
AND
sql_id='&sqlid'
/
FROM
v$sql t
JOIN
DBA_HIST_SQLBIND b using (sql_id)
WHERE
b.value_string is not null
AND
sql_id='&sqlid'
/
Comments
Post a Comment