DBA Data[Home] [Help]

SYS.DBMS_SQL_MONITOR dependencies on XMLTYPE

Line 382: -- is only XML, hence the return type is xmltype.

378: --
379: -- DESCRIPTION:
380: --
381: -- Same as above function (report_sql_monitor()) except that the result
382: -- is only XML, hence the return type is xmltype.
383: --
384: -----------------------------------------------------------------------------
385: FUNCTION report_sql_monitor_xml(
386: sql_id in varchar2 default NULL,

Line 408: return xmltype;

404: report_level in varchar2 default 'TYPICAL',
405: auto_refresh in number default NULL,
406: sql_plan_hash_value in number default NULL,
407: con_name in varchar2 default NULL)
408: return xmltype;
409:
410:
411: ---------------------------- report_sql_monitor_list ------------------------
412: -- NAME:

Line 526: -- is only XML, hence the return type is xmltype

522: --
523: -- DESCRIPTION:
524: --
525: -- Same as above function (report_sql_monitor) except that the result
526: -- is only XML, hence the return type is xmltype
527: --
528: --
529: -- RETURN:
530: -- An XML document for the list of SQL statements that have been

Line 552: RETURN xmltype;

548: report_level in varchar2 default 'TYPICAL',
549: auto_refresh in number default NULL,
550: base_path in varchar2 default NULL,
551: con_name in varchar2 default NULL)
552: RETURN xmltype;
553:
554:
555: END dbms_sql_monitor;