SYS.DBMS_FEATURE_CONCURRENT_STATS dependencies on XMLTYPE

Line 21: where extractvalue(xmltype(notes),

17: -- cursor to get the types of stats gathering operations which were
18: -- were performed concurrently.
19: CURSOR op_type_cursor IS
20: select operation op, count(*) cnt from dba_optstat_operations
21: where extractvalue(xmltype(notes),
22: '/params/param[@name="concurrent"]/@val') = 'TRUE'
23: group by operation
24: order by 2 desc;
25:

Line 63: WHERE extractvalue(xmltype(notes),

59: -- get the number of concurrent stats gathering operations
60: SELECT count(*)
61: INTO num_conc_ops
62: FROM dba_optstat_operations
63: WHERE extractvalue(xmltype(notes),
64: '/params/param[@name="concurrent"]/@val') = 'TRUE';
65:
66: tmp_buf := 'Total Number of Concurrent Operations: ' || num_conc_ops || '.'
67: || NEW_LINE ||