SYS.DBMS_FEATURE_AUTO_REOPT dependencies on DBMS_LOB

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

12: num_reopt_queries NUMBER; -- number of reoptimizable queries
13: tmp_buf VARCHAR2(32767);
14:
15: BEGIN
16: dbms_lob.createtemporary(feature_info, TRUE);
17:
18: select ksppstvl
19: into reporting_param
20: from x$ksppi x, x$ksppcv y where (x.indx = y.indx) and

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

47:
48: tmp_buf := 'Total number of queries: ' || num_all_queries ||
49: NEW_LINE ;
50:
51: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
52:
53: tmp_buf := 'Number of reoptimizable queries: ' || num_reopt_queries ||
54: NEW_LINE ;
55:

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

52:
53: tmp_buf := 'Number of reoptimizable queries: ' || num_reopt_queries ||
54: NEW_LINE ;
55:
56: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
57:
58: tmp_buf := 'Percentage of reoptimizable queries: ' ||
59: 100*num_reopt_queries/num_all_queries ||
60: NEW_LINE ;

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

58: tmp_buf := 'Percentage of reoptimizable queries: ' ||
59: 100*num_reopt_queries/num_all_queries ||
60: NEW_LINE ;
61:
62: dbms_lob.writeappend(feature_info, length(tmp_buf), tmp_buf);
63:
64: END dbms_feature_auto_reopt;