5.63 DBA_HIST_SQLBIND
DBA_HIST_SQLBIND
displays historical information on bind variables used by SQL cursors.
This view contains snapshots of V$SQL_BIND_CAPTURE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
SQL identifier of the parent cursor in the library cache |
|
|
|
Name of the bind variable |
|
|
|
Position of the bind variable in the SQL statement |
|
|
|
If the binding is performed by name and the bind variable is duplicated, then this column gives the position of the primary bind variable. |
|
|
|
Internal identifier for the bind data type. Beginning in Oracle Database 12c, a number representing a PL/SQL data type can appear in this column. |
|
|
|
Textual representation of the bind data type. Beginning in Oracle Database 12c, a text representation of a PL/SQL-only data type can appear in this column. If the actual data type is a PL/SQL sub type, the name of the data type, not the sub type will be displayed. |
|
|
|
National character set identifier |
|
|
|
Precision (for numeric binds) |
|
|
|
Scale (for numeric binds) |
|
|
|
Maximum bind length |
|
|
|
Indicates whether the bind value was captured ( |
|
|
|
Date when the bind value was captured. Bind values are captured when SQL statements are executed. To limit the overhead, binds are captured at most every 15 minutes for a given cursor. |
|
|
|
Value of the bind represented as a string |
|
|
|
Value of the bind represented using the self-descriptive |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: