SYS.DBMS_SQLTUNE dependencies on SQL_BIND

Line 141: bind_list IN sql_binds := NULL,

137: -- To be done
138: -----------------------------------------------------------------------------
139: FUNCTION create_tuning_task(
140: sql_text IN CLOB,
141: bind_list IN sql_binds := NULL,
142: user_name IN VARCHAR2 := NULL,
143: scope IN VARCHAR2 := SCOPE_COMPREHENSIVE,
144: time_limit IN NUMBER := TIME_LIMIT_DEFAULT,
145: task_name IN VARCHAR2 := NULL,

Line 1234: -- SQL_BINDS,

1230: -- context attributes like module, action, etc
1231: -- + List of comma separated attribute names to
1232: -- update: EXECUTION_CONTEXT,
1233: -- EXECUTION_STATISTICS,
1234: -- SQL_BINDS,
1235: -- SQL_PLAN,
1236: -- SQL_PLAN_STATISTICS: similar to
1237: -- SQL_PLAN + row source statistics.
1238: -- update_condition (IN) - specifies a where clause to execute the update

Line 1484: -- SQL_BINDS,

1480: -- + Comma separated list of attribute names:
1481: -- this allows to return only a subset of
1482: -- SQL attributes:
1483: -- EXECUTION_STATISTICS,
1484: -- SQL_BINDS,
1485: -- SQL_PLAN,
1486: -- SQL_PLAN_STATISTICS: similar to
1487: -- SQL_PLAN + row source statistics.
1488: -- plan_filter (IN) - plan filter. It is applicable in case there

Line 1562: -- SQL_BINDS,

1558: -- + Comma separated list of attribute names:
1559: -- this allows to return only a subset of
1560: -- SQL attributes:
1561: -- EXECUTION_STATISTICS,
1562: -- SQL_BINDS,
1563: -- SQL_PLAN,
1564: -- SQL_PLAN_STATISTICS: similar
1565: -- to SQL_PLAN + row source statistics
1566: --

Line 1622: -- SQL_BINDS,

1618: -- + Comma separated list of attribute names:
1619: -- this allows to return only a subset of
1620: -- SQL attributes:
1621: -- EXECUTION_STATISTICS,
1622: -- SQL_BINDS,
1623: -- SQL_PLAN,
1624: -- SQL_PLAN_STATISTICS: similar
1625: -- to SQL_PLAN + row source statistics
1626: -- recursive_sql (IN) - filter out the recursive SQL

Line 1817: -- SQL_BINDS,

1813: -- + Comma separated list of attribute names:
1814: -- this allows to return only a subset of
1815: -- SQL attributes:
1816: -- EXECUTION_STATISTICS,
1817: -- SQL_BINDS,
1818: -- SQL_PLAN,
1819: -- SQL_PLAN_STATISTICS: similar
1820: -- to SQL_PLAN + row source statistics
1821: --

Line 3332: -- - GV$SQL_BIND_CAPTURE

3328: -- - GV$ACTIVE_SESSION_HISTORY
3329: -- - GV$SQLAREA_PLAN_HASH
3330: -- - GV$SQL
3331: -- - GV$SQL_SHARED_CURSOR
3332: -- - GV$SQL_BIND_CAPTURE
3333: -- - V$DATABASE
3334: -- - V$SESSION
3335: -- - GV$PARAMETER
3336: -- - DBA_HIST_* views

Line 3416: -- the bind (see object type SQL_BIND).

3412: -- Given the value of a bind_data column captured in v$sql and a
3413: -- bind position, this function returns the value of the bind
3414: -- variable at that position in the SQL statement. Bind position
3415: -- start at 1. This function returns value and type information for
3416: -- the bind (see object type SQL_BIND).
3417: --
3418: -- PARAMETERS:
3419: -- bind_data (IN) - value of bind_data column from v$sql
3420: -- position (IN) - bind position in the statement (starts from 1)

Line 3431: -- name of the bind in SQL_BIND object is not populated by this function

3427: -- - bind position is invalid or out-of-bound
3428: -- - the specified bind_data is NULL.
3429: --
3430: -- NOTE:
3431: -- name of the bind in SQL_BIND object is not populated by this function
3432: -----------------------------------------------------------------------------
3433: FUNCTION extract_bind(
3434: bind_data IN RAW,
3435: bind_pos IN PLS_INTEGER) RETURN SQL_BIND;

Line 3435: bind_pos IN PLS_INTEGER) RETURN SQL_BIND;

3431: -- name of the bind in SQL_BIND object is not populated by this function
3432: -----------------------------------------------------------------------------
3433: FUNCTION extract_bind(
3434: bind_data IN RAW,
3435: bind_pos IN PLS_INTEGER) RETURN SQL_BIND;
3436:
3437: --------------------------------- extract_binds -----------------------------
3438: -- NAME:
3439: -- extract_binds

Line 3451: -- type sql_bind.

3447: -- bind_data (IN) - value of bind_data column from v$sql
3448: --
3449: -- RETURN:
3450: -- This function returns collection (list) of bind values of
3451: -- type sql_bind.
3452: --
3453: -- NOTE:
3454: -- For the content of a bind value, refer to function extract_bind
3455: ----------------------------------------------------------------------------

Line 3458: RETURN SQL_BIND_SET PIPELINED;

3454: -- For the content of a bind value, refer to function extract_bind
3455: ----------------------------------------------------------------------------
3456: FUNCTION extract_binds(
3457: bind_data IN RAW)
3458: RETURN SQL_BIND_SET PIPELINED;
3459:
3460:
3461: ----------------------------------------------------------------------------
3462: -- --