Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


DBA_HIST_SQL_BIND_METADATA displays historical information on metadata for bind variables used by SQL cursors.

Column Datatype NULL Description
DBID NUMBER NOT NULL Database ID for the snapshot
SQL_ID VARCHAR2(13) NOT NULL SQL identifier of the parent cursor in the library cache
NAME VARCHAR2(30)   Name of the bind variable
POSITION NUMBER NOT NULL Position of the bind variable in the SQL statement
DUP_POSITION NUMBER   If the binding is performed by name and the bind variable is duplicated, then this column gives the position of the primary bind variable
DATATYPE NUMBER   Internal identifier for the bind datatype
DATATYPE_STRING VARCHAR2(15)   Textual representation of the bind datatype
CHARACTER_SID NUMBER   National character set identifier
PRECISION NUMBER   Precision (for numeric binds)
SCALE NUMBER   Scale (for numeric binds)
MAX_LENGTH NUMBER   Maximum bind length