6.61 DBA_HIST_SQL_BIND_METADATA
DBA_HIST_SQL_BIND_METADATA
displays historical information on metadata for bind variables used by SQL cursors.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Database ID 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 |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|