License Knowledge Transfer

Get Started - Oracle Database Licenses

Marcel Lamarca André Sousa

Exadata Cloud Specialist ISV Specialist

LAD - Partner Enablement Knowledge Team

October, 2023
 SQL> select * from person where name = ‘Marcel Lamarca’
Father, husband, Cooker and son!

Graduated in Business Administration (FMU-SP)

Oracle DBA
21 Years dedicated to study and support Oracle Databases.
12 Years working with Exadata (On-prem, C@C and Cloud Services) .
4 Year working for Oracle do Brasil
1 Year on Alliances LAD knowledge Team

Oracle Cloud Specialist (OCS)

Exadata Database Machine X9M Certified Specialist
OCI Foundation 2020 / 2023
Oracle Autonomous Database Administrator
Oracle Cloud Database Migration and Integration
OCI Cloud Certified Architect Associate 2022
OCI Cloud Certified Architect Professional 2022
OCI Multicloud Architect Professional

Oracle Certified Professional (OCP)

10g, 11g and 12c.

Oracle Certified Specialist (OCE)

Grid/RAC Database Administrator 11g

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 SQL> select * from person where name = ‘Andre Sousa’

Janes and Raul's father, Son, Husband 25 years, dba old school

Graduated in Information Systems

I live a little away from everything even before the world changes

I'm working in Oracle for 21 with Oracle Database products adoption

in South America, work mainly with ISVs and SIs helping them on
different activities such as POCs, Application Validations, Tuning, he
participated as advisor in more than 100 Migration and Upgrade
projects.

Oracle Certified Professional 11g (OCP)

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Agenda

1 2 3 4
Licenses concepts Oracle Support Oracle Cloud Oracle
Database
License types
Oracle Support Types OCI License Manager
License Metrics Standard Edition
Oracle Support Pricing BYOL
Oracle Price List Enterprise Edition
Database Timeline License included
Hard Partition Oracle Price List
Support Rewards Universal Credits
Soft Partition

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 License basic concepts

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Full Use license Application Specific Full (ASFU)

Full Use license is without restrictions and allows Use is specific to run only with the defined application
usage that is full functionality. and may come with additional restrictions.

you don’t have Limitations to install third Share the same Datatabe with another applications
applications including Oracle Tools. and tools are not allowed.

Application Examples : SAP, Oracle Business Suite, ISV

Not Allowed examples :

• Sqlplus connections
• Golden Gate connections
• Sql Developer connections

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

General Licensing Information Environments

Use of Oracle Software requires Customers to license the respective Oracle programs in :

• Production Environments

• Non Production Environments such as:

 Development

 Quality Assurance/Testing & Staging

 Disaster Recovery

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 CPU vCPU
• Virtual Central Processing Unit
• Central Processing Unit
• It can be a color or a thread depending on the virtualize
• May contain one or more cores software
• Better Known as Socket or Processing Chip
• Used as a metric for other clouds (AWS and Azure
• Used as a metric for Oracle Standard 2 licensing
• There is NO Core Factor

OCPU Core

• Processing unit that Oracle uses to create its services

in OCI • Core or physical subdivision of a CPU

• For BYOL it is used as a metric for licensing, and the core

• Used as a metric for DBE licensing
factor applies

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Software Licensing Metrics

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Named User Plus VS Processor Metric Definition

Named User Plus (NUP) Processor Metric

Metric is defined as individuals authorized to use The Processor metric is used to license all processors
Oracle programs installed on single or multiple where Oracle programs are installed and/or running.
servers. Licensing considerations include:

• Most Standard Edition products are licensed by

• Human and non-human operated devices are Processor, which for Standard Edition programs is
counted towards NUP license defined as a socket

• Batch processing from computer to computer is

• Enterprise Edition and other technology products
permitted and does not require counting users at the
may be licensed by cores
front of the batch process

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Core Factor table

• Core factor gives you the delta to calculate Database Enterprise licenses
number by processor

• Oracle strongly recomends check on-line documentation to be aware of

all recent changes

• Core factor is used to calculate Database Enterprise Features too

• Last update on Septermber, 5 2023

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Database 19C Editions

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Database Standard Edition Oracle Database Enterprise Edition

Oracle Database 19c Standard Edition 2 has some

Is the most complete version of Oracle database software,
limitations compared to the Enterprise Edition.
core-based licensing.

• Lisensed by physical socket (core Factor not allowed) • There is no limit for core usage

• The delta to calculate CPU lisenses is :

• Oracle consider the socket factor limited by 2 sokets
(# of cores x core factor = # of Processor licenses)

• Standard Edition model using NUP metric requires

at least >10 users • Enterprise Edition model using NUP metric requires at
least >25 users per processor lisences

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Oracle Database Standard Edition VS Enterprise Edition

Security Features/Option Enterprise Edition Standard Edition

Database Security Assessment Tool  
Data Safe  
Password Profiles  
Strong Authentication  
Network Encryption  
Oracle RAC  ⦸
Oracle RAC one node  ⦸
Unified Audit  
Oracle Active Data Guard  ⦸
Transparent Data Encryption  ⦸
Management Pack for Oracle Database  ⦸
Oracle Diagnostics Pack  ⦸
Oracle Tuning Pack  ⦸
Oracle Partition  ⦸
Oracle Advanced compression  ⦸
Real Application Test  ⦸
Copyright © 2023, Oracle and/or its affiliates. All rights reserved
Oracle Database 19c Edition limitation, products and features

• Support Policy for Generic SQL Performance Issues (Doc ID 1198303.1)

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Database on Virtualized
Environments

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 What is Partitioning?

“Partitioning” occurs when the CPUs on a server are separated into individual
sections where each section acts as a separate system.

There are several hardware and software virtualization technologies available that
deliver partitioning capabilities, with varying degree of resource allocation flexibility.”

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Why Partition ?

• Database Administrators (DBAs) often partition servers to achieve the following benefits:

• Ability to run multiple operating systems, or multiple versions of an operating system, on the same
server

• Ability to improve workload balancing and distribution by managing processor allocations across applications and
users on the server

• Ability to leverage hardware models such as “Capacity on Demand” and "Pay As You Grow.”

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Hard Partitioning Soft Partitioning

Hard partitioning physically segments a server, by taking Soft partitioning segments the operating system using OS
a single large server and separating it into distinct resource managers.
smaller systems.
The operating system limits the number of CPUs where an
Each separated system acts as a physically independent. Oracle database is running by creating areas where CPU
resources are allocated.
Examples :
Examples :

• Hard Partitioning - LPAR

• Soft Partitioning - VSphere

• Hard Partitioning - LDOM

• Soft Partitioning - HyperV

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Understanding Price List Table

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Understanding price list table

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Licensing Oracle Enterprise Database Sample

15 Warehouse Distribution Scanners Current distribution company has 40 named

users between Employees and Warehouse
scanners.
Oracle Database EE

25 Delivery Employees using

held devices
Oracle Database Enterprise Edition is running on :
Custom Application

4 Processors
• 2 Processors server
• 12 Cores per processor
• 0.5 Core Factor

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Let's check some numbers ?

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 (# of cores x core factor = # of Processor licenses)
• 2 Processors server
• 12 Cores per processor
• 0.5 Core Factor
2 Processor 12 Cores 24 Cores

24 Cores 0.5 Core factor 12 Processor licenses required

By Core Factor

By Named User NUP

12 Processor licenses 25 (user minimum) 300 Named User Plus user

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 • 2 Processors server
• 12 Cores per processor
• 0.5 Core Factor

12 Processor licenses U$ 47,500 U$ 570,000 License Fee

12 Processor licenses U$ 10,450 U$ 125.400 Support Fee

By Processor License

By Named User Plus

300 Named Users Plus U$ 950 U$ 285,000 License Fee

300 Named Users Plus U$ 209 U$ 62,700 Support Fee

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 • 2 Processors server
• 12 Cores per processor
• 0.5 Core Factor
• Advanced Compression

12 Processor licenses U$ 11,500 U$ 138,000 License Fee

12 Processor licenses U$ 2,530.00 U$ 30,360 Support Fee

By Processor License

By Named User Plus

300 Named Users Plus U$ 230 U$ 69,000 License Fee

300 Named Users Plus U$ 50,60 U$ 15,180 Support Fee

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 OCI License Manager

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 BYOL License included

BYOL stands for “bring your own license.” You just pay for what you use and don’t worry about
anything else.
Oracle BYOL allows our customers to apply
licenses they currently own for on-premises You are eligible to use all the database options that are
software for equivalent, highly automated Oracle included in your service.
PaaS.

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Online, Elastic Scaling with OCI Oracle Databases
Pay Only for What You Use

Total Processor Resources

Manually or Auto Scaled vCPUs
Unused
Resources

Processor Usage Processor Usage

On-Premises – Static Cloud Database – Elastic

Purchase server processors and software Adjust enabled vCPUs to match actual workload
licenses for highest projected peak load via APIs and web UI - vCPUs are charged per second

Copyright © 2023, Oracle and/or its affiliates, All rights reserved

Reduce TCO moving to Autonomous Standard

Software cost totals

Oracle Autonomous On-premises Oracle
Database Database Standard Edition

$ 46,398 $ 4,350

Labor cost totals

Oracle Autonomous On-premises Oracle

Database Database Standard Edition

$ 3,552 $ 11,853

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

License Manager for Oracle Cloud Infrastructure

“If you’re thinking about moving your Oracle Database workloads to Oracle Cloud
Infrastructure (OCI), you’re probably worried about license portability and being able
to track your license utilization.

Your teams in charge of procurement and software asset management are probably
also worried about understanding utilization to forecast needs and track when
licenses expire.”

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

OCI License Manager Blog

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

OCI License Manager Console Options

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle PaaS and IaaS Universal Credits Description

Pay as You Go (PAYG)

• No upfront commitment

• Pay only for what you use

• Pay in arrears based on usage

• Built for land and expand

Universal Credits

• Agreed-to monthly spend

• Additional discounts based on size and term of deal

• Elastic payments based on usage

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Database Support

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Release Schedule of Current Database Releases (Doc ID 742060.1)

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Oracle Software support Types

Software updates, Security alerts and updates, Security alert and updates,
Critical patch updates,
Premier Support Tax, legal and regulatory updates, Upgrade tools and scripts, 24/7 assistance
with service requests

Software updates, Security alerts and updates, Security alert and updates,
Critical patch updates,
Extended Support Tax, legal and regulatory updates, Upgrade tools and scripts, 24/7 assistance
with service requests

Major product and technology releases, 24/7 assistance with service requests
Sustaining Support

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Useful Help channels

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Service Request Types: Technical vs Non-Technical

SR Type Problem Required Privileges

Technical
• Restricted privilege assigned by CUA
• Product related
• Create – View - None

Non-Technical • Permissions - Login • All users

• Create - Update – and View your own
• License - Entitlement

Or send an e-mail to : infoprice@oracle.com

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Software Investiment Advisor

For more informatio contact sia-global_ww@oracle.com or visit www.oracle.com/goto/sia

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Cloud Cost Estimator

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Rewards Program

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Oracle Support Rewards program

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Oracle Support Rewards Start Guide

• Accrue rewards for every dollar spent on OCI

• Reduce your technology support bill

• Combine with other support programs

• For every dollar spent on OCI, you can accrue $0.25 in Oracle Support Rewards

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Oracle Support Rewards on the console

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Oracle Support Rewards Dashboard

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Resources

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle global price list site

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Oracle Exadata Licenses information

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

Useful licenses links and references
• Oracle Database licensing :
www.oracle.com/assets/databaselicensing-070584.pdf
• Oracle Processor Core Factor Table :
www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdf

• Partitioning :
www.oracle.com/us/corporate/pricing/partitioning-070609.pdf
• Licensing on cloud Environments:
www.oracle.com/us/corporate/pricing/cloud-licensing-070579.pdf

• Data transfer licensing on Cloud environment

www.oracle.com/us/corporate/pricing/data-transfer-licensing-070590.pdf

• Oracle Licenses e-mail

infoprice@oracle.com

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

• Microsoft Licensing on Oracle Cloud Infrastructure :
https://docs.oracle.com/en-us/iaas/Content/Compute/References/microsoftlicensing.htm

• Oracle Cloud Vmware Solution :

https://www.oracle.com/cloud/compute/vmware

• Oracle Vmware Licences Write Paper

https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/whitepaper/solutions/oracle/un
derstanding_oracle_certification_support_licensing_vmware_environments-white-paper.pdf

• Oracle Contracts :
https://www.oracle.com/cloud/compute/vmware

• Oracle Cost Estimator documentation :

https://docs.oracle.com/en-us/iaas/Content/GSG/Tasks/signingup_topic-Estimating_Costs.htm

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

• Oracle Cloud License Manager :

https://docs.oracle.com/pt-br/iaas/Content/LicenseManager/Concepts/licensemanageroverview.htm

• Licensing Data Recovery Environments

https://www.oracle.com/assets/data-recovery-licensing-070587.pdf

Copyright © 2023, Oracle and/or its affiliates. All rights reserved

 Thank You 

Questions / Feedback / Training Suggestions

andre.sousa@oracle.com

marcel.lamarca@oracle.com

Ask for help 

Copyright © 2023, Oracle and/or its affiliates. All rights reserved