SYS.DBMS_XPLAN dependencies on DBMS_XPLAN_TYPE_TABLE

Line 600: return dbms_xplan_type_table

596: function display(table_name varchar2 default 'PLAN_TABLE',
597: statement_id varchar2 default null,
598: format varchar2 default 'TYPICAL',
599: filter_preds varchar2 default null)
600: return dbms_xplan_type_table
601: pipelined;
602:
603: -- display from V$SQL_PLAN (or V$SQL_PLAN_STATISTICS_ALL)
604: function display_cursor(sql_id varchar2 default null,

Line 607: return dbms_xplan_type_table

603: -- display from V$SQL_PLAN (or V$SQL_PLAN_STATISTICS_ALL)
604: function display_cursor(sql_id varchar2 default null,
605: cursor_child_no integer default 0,
606: format varchar2 default 'TYPICAL')
607: return dbms_xplan_type_table
608: pipelined;
609:
610: -- display from AWR
611: function display_awr(sql_id varchar2,

Line 616: return dbms_xplan_type_table

612: plan_hash_value integer default null,
613: db_id integer default null,
614: format varchar2 default 'TYPICAL',
615: con_id integer default null)
616: return dbms_xplan_type_table
617: pipelined;
618:
619: -- display from SQL tuning set
620: function display_sqlset(sqlset_name varchar2,

Line 625: return dbms_xplan_type_table

621: sql_id varchar2,
622: plan_hash_value integer default null,
623: format varchar2 default 'TYPICAL',
624: sqlset_owner varchar2 default null)
625: return dbms_xplan_type_table
626: pipelined;
627:
628: -- display from SQL plan baseline
629: function display_sql_plan_baseline(sql_handle varchar2 default null,

Line 632: return dbms_xplan_type_table

628: -- display from SQL plan baseline
629: function display_sql_plan_baseline(sql_handle varchar2 default null,
630: plan_name varchar2 default null,
631: format varchar2 default 'TYPICAL')
632: return dbms_xplan_type_table
633: pipelined;
634:
635: -- display from SQL profile
636: function display_sql_profile_plan(name varchar2,

Line 638: return dbms_xplan_type_table

634:
635: -- display from SQL profile
636: function display_sql_profile_plan(name varchar2,
637: format varchar2 default 'TYPICAL')
638: return dbms_xplan_type_table
639: pipelined;
640:
641: -- display from SQL patch
642: function display_sql_patch_plan(name varchar2,

Line 644: return dbms_xplan_type_table

640:
641: -- display from SQL patch
642: function display_sql_patch_plan(name varchar2,
643: format varchar2 default 'TYPICAL')
644: return dbms_xplan_type_table
645: pipelined;
646:
647: ----------------------------------------------------------------------------
648: -- ---------------------------------------------------------------------- --

Line 659: return dbms_xplan_type_table

655: -- private procedure, used internally
656: function prepare_records(plan_cur IN sys_refcursor,
657: i_format_flags IN number,
658: diag_repos_cur IN sys_refcursor default null)
659: return dbms_xplan_type_table
660: pipelined;
661:
662: -- private function to validate the user format (used internally)
663: function validate_format(hasPlanStats IN boolean,

Line 683: RETURN dbms_xplan_type_table

679:
680: FUNCTION i_display_smb_plan(name IN VARCHAR2,
681: format IN VARCHAR2 DEFAULT 'TYPICAL',
682: obj_type IN NUMBER )
683: RETURN dbms_xplan_type_table
684: pipelined;
685:
686: --
687: -- formats a number representing time in seconds using the format HH:MM:SS.