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:
■ Reference to the cursor defining the bind variable
(hash_value, address) for the parent cursor and (hash_value, child_
address) for the child cursor.
■ Bind metadata
Name, position, datatype, character set ID, precision, scale, and maximum length
of the bind variable.
■ Bind data
One of the bind values used for the bind variable during a past execution of its
associated SQL statement. Bind values are not always captured for this view. Bind
values are displayed by this view only when the type of the bind variable is simple
(this excludes LONG, LOB, and ADT datatypes) and when the bind variable is
used in the WHERE or HAVING clauses of the SQL statement.
Bind capture is disabled when the STATISTICS_LEVEL initialization parameter is set
to BASIC. This view can be joined with V$SQLAREA on (HASH_VALUE, ADDRESS) and
with V$SQL on (HASH_VALUE, CHILD_ADDRESS).[@more@]
Each row in the view contains information for one bind variable defined in a cursor.
This includes:
■ Reference to the cursor defining the bind variable
(hash_value, address) for the parent cursor and (hash_value, child_
address) for the child cursor.
■ Bind metadata
Name, position, datatype, character set ID, precision, scale, and maximum length
of the bind variable.
■ Bind data
One of the bind values used for the bind variable during a past execution of its
associated SQL statement. Bind values are not always captured for this view. Bind
values are displayed by this view only when the type of the bind variable is simple
(this excludes LONG, LOB, and ADT datatypes) and when the bind variable is
used in the WHERE or HAVING clauses of the SQL statement.
Bind capture is disabled when the STATISTICS_LEVEL initialization parameter is set
to BASIC. This view can be joined with V$SQLAREA on (HASH_VALUE, ADDRESS) and
with V$SQL on (HASH_VALUE, CHILD_ADDRESS).[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-1002841/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-1002841/