V$SQL_BIND_DATA definition in Oracle Database 11.2
V$SQL_BIND_DATA

select
  CURSOR_NUM,                              -- CURSOR_NUM NUMBER
  POSITION,                                -- POSITION NUMBER
  DATATYPE,                                -- DATATYPE NUMBER
  SHARED_MAX_LEN,                          -- SHARED_MAX_LEN NUMBER
  PRIVATE_MAX_LEN,                         -- PRIVATE_MAX_LEN NUMBER
  ARRAY_SIZE,                              -- ARRAY_SIZE NUMBER
  PRECISION,                               -- PRECISION NUMBER
  SCALE,                                   -- SCALE NUMBER
  SHARED_FLAG,                             -- SHARED_FLAG NUMBER
  SHARED_FLAG2,                            -- SHARED_FLAG2 NUMBER
  BUF_ADDRESS,                             -- BUF_ADDRESS RAW(8)
  BUF_LENGTH,                              -- BUF_LENGTH NUMBER
  VAL_LENGTH,                              -- VAL_LENGTH NUMBER
  BUF_FLAG,                                -- BUF_FLAG NUMBER
  INDICATOR,                               -- INDICATOR NUMBER
  VALUE                                    -- VALUE VARCHAR2(4000)
from
  GV$SQL_BIND_DATA
where
  inst_id = USERENV('Instance')

home |  up