For each distinct bind variable in each cursor owned by the session querying this view, this view describes:

  • Bind metadata provided by the client, if the bind variable is user defined

  • Metadata based on the underlying literal, if the CURSOR_SHARING parameter is set to FORCE and the bind variable is system-generated.

    Column Datatype Description
    ADDRESS RAW(4 | 8) Memory address of the child cursor that owns this bind variable
    POSITION NUMBER Bind position
    DATATYPE NUMBER Bind datatype
    MAX_LENGTH NUMBER Maximum length of the bind value
    ARRAY_LEN NUMBER Maximum number of array elements (for array binds only)
    BIND_NAME VARCHAR2(30) User-defined or system-generated bind variable name (if used)