SYS.DBMS_FEATURE_CONCURRENT_STATS dependencies on DBMS_LOB

Line 27: dbms_lob.createtemporary(feature_info, TRUE);

23: group by operation
24: order by 2 desc;
25:
26: BEGIN
27: dbms_lob.createtemporary(feature_info, TRUE);
28:
29: -- get the time interval reported in dba_optstat_operations
30: select to_char(min(start_time), 'MM/DD/YYYY'),
31: to_char(max(start_time), 'MM/DD/YYYY')

Line 37: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);

33: from dba_optstat_operations;
34:
35: tmp_buf := 'Time interval covered by dba_optstat_operations: '||
36: interval_start || ' - ' || interval_end || NEW_LINE;
37: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
38:
39: -- get the total number of rows in dba_optstat_operations
40: SELECT count(*)
41: INTO num_all_ops

Line 46: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);

42: FROM dba_optstat_operations;
43:
44: tmp_buf := 'Total Number of All Stats Operations: '|| num_all_ops
45: || NEW_LINE;
46: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
47:
48: -- get the number of gather stats operations which is eligible to be run
49: -- concurrently
50: SELECT count(*)

Line 57: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);

53: WHERE operation like 'gather%';
54:
55: tmp_buf := 'Total Number of Gather Stats Operations: '|| num_gath_ops
56: || NEW_LINE;
57: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
58:
59: -- get the number of concurrent stats gathering operations
60: SELECT count(*)
61: INTO num_conc_ops

Line 70: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);

66: tmp_buf := 'Total Number of Concurrent Operations: ' || num_conc_ops || '.'
67: || NEW_LINE ||
68: 'Types of concurrent operations with their frequencies:'
69: || NEW_LINE;
70: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
71:
72: -- # of concurrent operations group by the kind of operation
73: for op_type_iter in op_type_cursor
74: loop

Line 77: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);

73: for op_type_iter in op_type_cursor
74: loop
75: tmp_buf := ' ' || op_type_iter.op ||': '||
76: op_type_iter.cnt || NEW_LINE;
77: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
78: end loop;
79:
80: -- value of "concurrent" preference
81: select dbms_stats.get_prefs('CONCURRENT')

Line 86: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);

82: into conc_pref
83: from dual;
84:
85: tmp_buf := 'Current value of CONCURRENT preference: '|| conc_pref || NEW_LINE;
86: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
87:
88: -- populate the outputs if concurrent stats gathering is enabled
89: if (num_conc_ops > 0 OR
90: upper(conc_pref) not in ('OFF', 'FALSE')) then