Friday, April 30, 2010

How To Verify Which Database Options are Used in Oracle

During installation one screen pops up saying “Warning, using these tools require additional license packs” and you have to click that you agree with the license to go on with the install. However, the functionality is installed, fully available and easily accessed. An argument could be made that only the person who actually does the install

In several cases Oracle has audited users and charged them heavy license fees for features they inadvertently (or deliberately) used such as AWR and SQL Analyzer, one thing to remember, accessing the AWR views (DBA_HIST), session history views (ASH) or running AWR reports constitutes use and requires a license.

So How you can check in the database which options or features are used. This is particular useful for licensing purposes or when you want to de-install a certain option. If you are not sure what features you or your users may have used, check out the DBA_FEATURE_USAGE_STATISTICS view





select name,version,detected_usages,currently_used,
first_usage_date,last_usage_date
from dba_feature_usage_statistics
where detected_usages >0
order by 1;
Note:also  dba_advisor_usage  record usage of  advisors

Related  Topics
How do I check How much Oracle licence needed for my database
How to find usage of Advisors in Oracle (DBA_ADVISOR_USAGE)

No comments: