How do I check How much Oracle licence needed for my database

We can  check HIGHWATER values from v$licence  (for  RAC gv$licence ).we  can use   whether cpu or  user  part  of  the  following  query   dependening  on    we  have  cpu  licence or named user licence.

select
 sessions_current,sessions_highwater,
 cpu_count_current,cpu_core_count_current,
 cpu_count_highwater,cpu_core_count_highwater
from V$LICENSE;

Note1: that  Oracle  apply diffrent  core/cpu conversion for  diffrent type of  machines.
(http://www.oracle.com/corporate/contracts/library/processor-core-factor-table.pdf)

Note2:In order  to prevent  limit overflow for  session license_max_sessions,license_max_users init.ora parameters

Related  Topics
How to find usage of Advisors in Oracle (DBA_ADVISOR_USAGE)
How To Verify Which Database Options are Used in Oracle

How to find usage of Advisors in Oracle (DBA_ADVISOR_USAGE)

There are views named dba_feature_usage_statistics and dba_advisor_usage which record usage of the new features. These reports indicate that the user needs to purchase the license for the additional products. In other words, usage of features like AWR, ASH and ADDM is recorded in the database

DBA_ADVISOR_USAGE displays the usage information for each type of advisor in the database

SQL>select u.ADVISOR_ID,d.ADVISOR_NAME,u.LAST_EXEC_TIME ,u.NUM_EXECS 
from DBA_ADVISOR_USAGE u,DBA_ADVISOR_DEFINITIONS d 
where u.ADVISOR_ID=d.ADVISOR_ID;

ADVISOR_ID ADVISOR_NAME LAST_EXEC_ NUM_EXECS
---------- ------------------------------ ---------- ---------
1 ADDM                              19/06/2008 2
2 SQL Access Advisor      22/07/2006 0
3 Undo Advisor                   22/07/2006 0
4 SQL Tuning Advisor        22/07/2006 0
5 Segment Advisor             28/04/2010 9436
6 SQL Workload Manager 22/07/2006 0
7 Tune MView                      22/07/2006 0


Related Topics
How do I check How much Oracle licence needed for my database
How To Verify Which Database Options are Used in Oracle

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)