--

-- Show feature usage.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET HEADING ON

SET LINESIZE 300

SET PAGESIZE 60

COLUMN name  FORMAT A45

COLUMN detected_usages FORMAT 9999

SELECT u1.name,

u1.detected_usages

FROM   dba_feature_usage_statistics u1

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

FROM   dba_feature_usage_statistics u2

WHERE  u2.name = u1.name)

ORDER BY u1.name

/