Monday, May 3, 2010

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

No comments: