324: BEGIN
325: --
326: -- Profile options value take precedance over default values
327: --
328: g_trace_level := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_LEVEL') , g_dflt_trace_level);
329: g_profiler := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_PROFILER') , g_dflt_profiler);
330: g_trace_datetime := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_DATETIME') , g_dflt_trace_datetime);
331: g_sqltrace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SQLTRACE') , g_dflt_sqltrace);
332: g_file_flush_option:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_FLUSH_OPTION'), g_dflt_file_flush_option);
325: --
326: -- Profile options value take precedance over default values
327: --
328: g_trace_level := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_LEVEL') , g_dflt_trace_level);
329: g_profiler := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_PROFILER') , g_dflt_profiler);
330: g_trace_datetime := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_DATETIME') , g_dflt_trace_datetime);
331: g_sqltrace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SQLTRACE') , g_dflt_sqltrace);
332: g_file_flush_option:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_FLUSH_OPTION'), g_dflt_file_flush_option);
333: g_file_override_directory
326: -- Profile options value take precedance over default values
327: --
328: g_trace_level := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_LEVEL') , g_dflt_trace_level);
329: g_profiler := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_PROFILER') , g_dflt_profiler);
330: g_trace_datetime := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_DATETIME') , g_dflt_trace_datetime);
331: g_sqltrace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SQLTRACE') , g_dflt_sqltrace);
332: g_file_flush_option:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_FLUSH_OPTION'), g_dflt_file_flush_option);
333: g_file_override_directory
334: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_DIRECTORY')
327: --
328: g_trace_level := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_LEVEL') , g_dflt_trace_level);
329: g_profiler := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_PROFILER') , g_dflt_profiler);
330: g_trace_datetime := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_DATETIME') , g_dflt_trace_datetime);
331: g_sqltrace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SQLTRACE') , g_dflt_sqltrace);
332: g_file_flush_option:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_FLUSH_OPTION'), g_dflt_file_flush_option);
333: g_file_override_directory
334: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_DIRECTORY')
335: , g_dflt_file_override_directory);
328: g_trace_level := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_LEVEL') , g_dflt_trace_level);
329: g_profiler := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_PROFILER') , g_dflt_profiler);
330: g_trace_datetime := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_DATETIME') , g_dflt_trace_datetime);
331: g_sqltrace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SQLTRACE') , g_dflt_sqltrace);
332: g_file_flush_option:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_FLUSH_OPTION'), g_dflt_file_flush_option);
333: g_file_override_directory
334: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_DIRECTORY')
335: , g_dflt_file_override_directory);
336: g_file_override_filename
330: g_trace_datetime := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE_DATETIME') , g_dflt_trace_datetime);
331: g_sqltrace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SQLTRACE') , g_dflt_sqltrace);
332: g_file_flush_option:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_FLUSH_OPTION'), g_dflt_file_flush_option);
333: g_file_override_directory
334: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_DIRECTORY')
335: , g_dflt_file_override_directory);
336: g_file_override_filename
337: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_FILENAME')
338: , g_dflt_file_override_filename);
333: g_file_override_directory
334: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_DIRECTORY')
335: , g_dflt_file_override_directory);
336: g_file_override_filename
337: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_FILENAME')
338: , g_dflt_file_override_filename);
339: g_trace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE') , g_dflt_trace);
340: g_srs_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_MODE') , g_dflt_srs_mode);
341: g_of_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_OF_MODE') , g_dflt_of_mode);
335: , g_dflt_file_override_directory);
336: g_file_override_filename
337: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_FILENAME')
338: , g_dflt_file_override_filename);
339: g_trace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE') , g_dflt_trace);
340: g_srs_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_MODE') , g_dflt_srs_mode);
341: g_of_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_OF_MODE') , g_dflt_of_mode);
342: g_timeout := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TIMEOUT') , g_dflt_timeout);
343: g_srs_output_enable:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_OUTPUT_ENABLE'), g_dflt_srs_output_enable);
336: g_file_override_filename
337: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_FILENAME')
338: , g_dflt_file_override_filename);
339: g_trace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE') , g_dflt_trace);
340: g_srs_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_MODE') , g_dflt_srs_mode);
341: g_of_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_OF_MODE') , g_dflt_of_mode);
342: g_timeout := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TIMEOUT') , g_dflt_timeout);
343: g_srs_output_enable:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_OUTPUT_ENABLE'), g_dflt_srs_output_enable);
344:
337: := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_FILE_OVERRIDE_FILENAME')
338: , g_dflt_file_override_filename);
339: g_trace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE') , g_dflt_trace);
340: g_srs_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_MODE') , g_dflt_srs_mode);
341: g_of_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_OF_MODE') , g_dflt_of_mode);
342: g_timeout := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TIMEOUT') , g_dflt_timeout);
343: g_srs_output_enable:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_OUTPUT_ENABLE'), g_dflt_srs_output_enable);
344:
345: --
338: , g_dflt_file_override_filename);
339: g_trace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE') , g_dflt_trace);
340: g_srs_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_MODE') , g_dflt_srs_mode);
341: g_of_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_OF_MODE') , g_dflt_of_mode);
342: g_timeout := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TIMEOUT') , g_dflt_timeout);
343: g_srs_output_enable:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_OUTPUT_ENABLE'), g_dflt_srs_output_enable);
344:
345: --
346: -- Evaluate the status of the statistics from both the profiler and the system statistics
339: g_trace := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TRACE') , g_dflt_trace);
340: g_srs_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_MODE') , g_dflt_srs_mode);
341: g_of_mode := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_OF_MODE') , g_dflt_of_mode);
342: g_timeout := NVL(xla_profiles_pkg.get_value('XLA_DEBUG_TIMEOUT') , g_dflt_timeout);
343: g_srs_output_enable:= NVL(xla_profiles_pkg.get_value('XLA_DEBUG_SRS_OUTPUT_ENABLE'), g_dflt_srs_output_enable);
344:
345: --
346: -- Evaluate the status of the statistics from both the profiler and the system statistics
347: --