Αποτελέσματα Αναζήτησης
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. This includes:
15 Μαρ 2021 · If you are licensed for sql monitoring, you can use V$SQL_MONITOR to get the binds, but similarly, this will be for queries that are being monitored (aka, long running queries only by default). If you really want to get *every* bind, then you pretty much have to resort to low level tracing via DBMS_MONITOR with 'binds' set to true.
1 Νοε 2017 · I know you can check v$sql and get a list of distinct SQLs after translating the constants in the predicates. But if it's using bind variable, shouldn't V$SQL_BIND_CAPTURE have that SQL_ID and also the values really used for the vari.
6 Ιουν 2022 · SQL> select NAME, VALUE_STRING from V$SQL_BIND_CAPTURE where SQL_ID = '43gugwnrgt1mf'; NAME VALUE_STRING ----- :DPT_ID01 80 :DPT_ID02 NULL 2 rows selected. A solution is to execute the SELECT like a 11.2 database.
24 Ιουλ 2008 · If you’ve ever looked at view v$sql_bind_capture, you’ve probably seen that (at least in 10.2) it allows you to see the actual values for bind variables that have been used with an SQL statement.
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. This includes: ( hash_value, address) for the parent cursor and ( hash_value, child_address) for the child cursor. Name, position, datatype, character set ID, precision, scale, and ...
V$ALL_SQL_BIND_CAPTURE allows application developers to view information about their own bind variables used by SQL cursors. It is similar to the V$SQL_BIND_CAPTURE view, with the following exception: When queried by the SYS user, or any user with the SYSDBA privilege, the V$ALL_SQL_BIND_CAPTURE view displays the same data as the V$SQL_BIND ...
