[Home] [Help]
4778: --
4779: procedure gather_processing_rate(gathering_mode IN VARCHAR2 DEFAULT 'START',
4780: duration IN NUMBER DEFAULT NULL);
4781:
4782: NULL_NUMTAB dbms_utility.number_array;
4783:
4784: --------------------------- report_stats_operations ----------------------------------
4785: -- NAME:
4786: -- report_stats_operations
4831: -- operations from all pluggable databases are reported.
4832: --
4833: --
4834: -- NOTES:
4835: -- Note that the type for container_ids input parameter is dbms_utility.number_array
4836: -- which is an associative PL/SQL array collection. Although associative array type
4837: -- allows for more flexible hash table-like organization of entries, this function treats
4838: -- container_ids as a regular table collection with the first id located at index 1 and
4839: -- the last id located at index "container_ids.count" without any empty array slot left
4839: -- the last id located at index "container_ids.count" without any empty array slot left
4840: -- between any two ids. An example for 3 container ids is provided below.
4841: --
4842: -- declare
4843: -- conid_tab dbms_utility.number_array;
4844: -- report clob;
4845: -- begin
4846: -- conid_tab(1) := 124;
4847: -- conid_tab(2) := 63;
4855: latestN number default null,
4856: since timestamp with time zone default null,
4857: until timestamp with time zone default null,
4858: auto_only boolean default false,
4859: container_ids dbms_utility.number_array
4860: default dbms_stats.NULL_NUMTAB)
4861: return clob;
4862:
4863: --------------------------- report_single_stats_operation -----------------------------