[Home] [Help]
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,
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
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
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: --
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
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: --