While many Oracle features are turned on by default, that does not necessarily mean you are using them.
If you want to check to see if a feature has been used and when it was last used, do something like this.
This examples checks an instance for partitioning usage. Why the “USER” in the where clause? Because Oracle uses some partitioned objects itself with SYS or SYSTEM owned objects.
select i.instance_name INSTANCE_NAME,
i.host_name HOST_NAME,
f.name FEATURE,
f.currently_used,
f.detected_usages,
f.last_usage_date
from dba_feature_usage_statistics f, v$instance i
where upper(f.name) like ‘%PARTITION%USER%’;
Hope this helps. Mike