[Home] [Help]
2856: --
2857: -- DESCRIPTION:
2858: --
2859: -- Same as above function (report_sql_monitor()) except that the result
2860: -- is only XML, hence the return type is xmltype and two additional
2861: -- input parameters for DB operations
2862: --
2863: -- - dbop_name DQOP_NAME for which DB operation should be displayed
2864: -- Use NULL to display any monitored DB operations
2892: dbop_name in varchar2 default NULL,
2893: dbop_exec_id in number default NULL,
2894: con_name in varchar2 default NULL,
2895: report_id in number default NULL)
2896: return xmltype;
2897:
2898:
2899: ---------------------------- report_sql_monitor_list ------------------------
2900: -- NAME:
3046: --
3047: -- DESCRIPTION:
3048: --
3049: -- Same as above function (report_sql_monitor) except that the result
3050: -- is only XML, hence the return type is xmltype
3051: --
3052: -- - dbop_name DQOP_NAME for which DB operation should be displayed
3053: -- Use NULL to display any monitored DB operations
3054: --
3120: top_n_rankby in varchar2 default 'last_active_time',
3121: top_n_detail_count in number default NULL,
3122: con_name in varchar2 default NULL,
3123: compress_xml in binary_integer := 0)
3124: RETURN xmltype;
3125:
3126: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
3127: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
3128: -- ------------------------------------------- --
3393: data_source in varchar2 default 'auto',
3394: end_time in date default NULL,
3395: duration_stats in number default NULL,
3396: con_name in varchar2 default NULL)
3397: return xmltype;
3398:
3399:
3400: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
3401: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
3491: bucket_interval in number default NULL,
3492: report_level in varchar2 default 'TYPICAL',
3493: cpu_cores in binary_integer default NULL,
3494: is_hyper in varchar2 default NULL)
3495: RETURN xmltype;
3496:
3497: --
3498: PROCEDURE check_sqlset_privs(
3499: sqlset_name IN VARCHAR2,
3611: ----------------------------------------------------------------------------
3612: FUNCTION report_tuning_task_list_xml(
3613: result_limit IN NUMBER := 100,
3614: autotune_period IN NUMBER := NULL)
3615: RETURN xmltype;
3616:
3617: ------------------------- report_tuning_task_xml ---------------------------
3618: -- NAME:
3619: -- report_tuning_task_xml - report a SQL tuning task xml
3677: owner_name IN VARCHAR2 := NULL,
3678: execution_name IN VARCHAR2 := NULL,
3679: autotune_period IN NUMBER := NULL,
3680: report_tag IN VARCHAR2 := NULL)
3681: RETURN xmltype;
3682:
3683: ------------------------------ check_tuning_task_status --------------------
3684: -- NAME:
3685: -- check_tuning_task - check status of the specified tuning task
3782: category IN VARCHAR2 := NULL,
3783: force_match IN NUMBER := 0,
3784: autotune_period IN NUMBER := NULL,
3785: show_sql_only IN NUMBER := 0)
3786: RETURN XMLTYPE;
3787:
3788: ---------------------------- alter_tuning_task_xml -------------------------
3789: -- NAME:
3790: -- alter_tuning_task_xml - alter an existing tuning task
3811: FUNCTION alter_tuning_task_xml(
3812: task_name IN VARCHAR2,
3813: action_type IN VARCHAR2,
3814: show_sql_only IN NUMBER := 0)
3815: RETURN XMLTYPE;
3816:
3817: --------------------------- configure_tuning_task_xml -----------------------
3818: -- NAME:
3819: -- configure_tuning_task_xml - configure an existing tuning task
3843: task_name IN VARCHAR2,
3844: task_parameters IN arglist,
3845: task_owner IN VARCHAR2 := NULL,
3846: show_sql_only IN NUMBER := 0)
3847: RETURN XMLTYPE;
3848:
3849: END dbms_sqltune;