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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment