-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com

-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.

PROMPT Did you flush feature usage information to the repository?

PROMPT >>> EXEC dbms_feature_usage_internal.exec_db_usage_sampling(SYSDATE)

SELECT ul.name, ul.detected_usages

FROM dba_feature_usage_statistics ul

WHERE ul.version = (SELECT MAX(u2.version)

FROM dba_feature_usage_statistics u2

WHERE ul.name = u2.name

AND UPPER(ul.name) LIKE UPPER('&1')

AND UPPER(u2.name) LIKE UPPER('&1')

)

/