DBA Data[Home] [Help]

SYS.DBMS_FEATURE_EMX dependencies on DBA_FEATURE_USAGE_STATISTICS

Line 77: from dba_feature_usage_statistics

73: -- last usage collection
74: begin
75: select nvl(aux_count, 0), feature_info
76: into l_count_total, l_detailed_usage_clob
77: from dba_feature_usage_statistics
78: where name = 'EM Express';
79: exception
80: when NO_DATA_FOUND then
81: l_count_total := 0;

Line 97: from dba_feature_usage_statistics;

93:
94: -- get last db feature usage collection time
95: select nvl(max(last_sample_date), sysdate-7)
96: into l_last_collection_time
97: from dba_feature_usage_statistics;
98:
99: -- get report usage info since last feature usage collection
100: for rc in emx_fu_cursor(l_last_collection_time)
101: loop