18 lines
676 B
SQL
18 lines
676 B
SQL
-- 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')
|
|
)
|
|
/
|
|
|