query oracle usage stats

research.oracle.usage.sql

--- # this GIST is available under the conditions of
--- # https://creativecommons.org/licenses/by/4.0/

SELECT
	MAX(LAST_SAMPLe_DATE) AS "Last use",
	NAME AS "Name",
	CAST (TO_CHAR(SUM(DETECTED_USAGES) / SUM(TOTAL_SAMPLES) * 100, '999') AS VARCHAR2(5)) AS "%"
FROM
	dba_feature_usage_statistics
WHERE
	CURRENTLY_USED = 'TRUE'
GROUP BY
	NAME,
	CURRENTLY_USED
HAVING
	SUM(DETECTED_USAGES) > 0
ORDER BY
	NAME ASC