36: l_cr INTEGER;
37:
38: BEGIN
39: --
40: -- To be uncommented when dbms_profiler is installed
41: --
42: l_cr := dbms_profiler.start_profiler(xla_utility_pkg.g_unique_location);
43:
44: NULL;
38: BEGIN
39: --
40: -- To be uncommented when dbms_profiler is installed
41: --
42: l_cr := dbms_profiler.start_profiler(xla_utility_pkg.g_unique_location);
43:
44: NULL;
45:
46: END start_profiler;
62: l_cr INTEGER;
63:
64: BEGIN
65: --
66: -- To be uncommented when dbms_profiler is installed
67: --
68: l_cr := dbms_profiler.stop_profiler;
69: l_cr := dbms_profiler.flush_data;
70:
64: BEGIN
65: --
66: -- To be uncommented when dbms_profiler is installed
67: --
68: l_cr := dbms_profiler.stop_profiler;
69: l_cr := dbms_profiler.flush_data;
70:
71: END stop_profiler;
72:
65: --
66: -- To be uncommented when dbms_profiler is installed
67: --
68: l_cr := dbms_profiler.stop_profiler;
69: l_cr := dbms_profiler.flush_data;
70:
71: END stop_profiler;
72:
73:
156: || 'FROM plsql_profiler_units '
157: || xla_environment_pkg.g_chr_newline
158: || 'WHERE runid = '||l_runid||' '
159: || xla_environment_pkg.g_chr_newline
160: || ' AND unit_name NOT IN (''DBMS_PROFILER'' '
161: || xla_environment_pkg.g_chr_newline
162: || ' ,''
163:
164: -- xla_utility_pkg.trace(l_statement_unit , 50);