Blogs

Four Oracle Database License Models.

When choosing an Oracle database license, you should consider the following aspects:

End customer license:

1. Full use license - Normally no restrictions simply follow the license terms and Oracle licensing rules and policies.

What You Need to Know About Oracle Licensing in Azure

There are a few things you need to know about Oracle licensing in Azure. For example, licensing for HyperThreading is not the same as for CPUs. Oracle licenses software by the number of processors it runs, and that includes virtual CPUs. It is also important to note that Oracle hasn't yet adopted standard rules for virtual CPUs. Oracle's licensing in the cloud applies special Cloud rules, which might make the process more difficult.

Oracle ULA - Strategies for IT professionals

Oracles unlimited license agreement has a mixed reputation in the market, and I will try to explain why
but also the benefits, drawbacks of the agreement. Then a suggested plan for how to manage the ULA
renewal or when you want to exit the agreement.

What is Oracle ULA?

Oracle license audits can cost companies millions in avoidable license fees.
Why do I wrote avoidable? - Because in my experience (300+ Oracle license audits)
90% of all out of compliance findings in Oracle license audit reports are
not due to over-usage but simply

a) Misunderstanding Oracle licensing rules
b) Misinterpreting Oracle licensing policies such as virtualization.

How should you "win" an Oracle license audit?

##############################################
#cd /c/temp/;spark-submit.cmd pysparknaivebayes.py

"""

NAIVE BAYES ALGORITHM IN SQL. PL/SQL, SPARK SQL
Written: JP Vijaykumar
Date: Mar 8th 2022
********************************************************************************
This script is provided for educational purpose ONLY.

DATA MIGRATION - USING - ASM DISK MIGRATION
--------------------------------------------
Author: JP Vijaykumar
Date: Jan 4th 2022

"""
Apriori Algorithm in sql,pl/sql and spark sql
Written JP Vijaykumar
Date Sep 14 2021

********************************************************************************
This script is provided for educational purpose only.

The sql scripts were tested in 11g & 19c databases.
While testing the sql scripts, pls test it in a dev/test db only and exercise precaution.

As from this weekend, it is here:

https://www.oracle.com/database/technologies/oracle21c-linux-downloads.html

I'll certainly install it in the next few days, there are a few features I want to experiment with and I know our developers want to check out the new JSON features. Production use? I'm not sure. It being an "innovation" release only with no extended support makes me a bit dubious.

ORDS version 21 was released in May, I had it tested and rolled it out in June. But once live, a problem popped up: numerous executions of this statement,
SELECT COUNT(1) FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'APEX_RELEASE' AND TABLE_NAME = 'APEX_RELEASE';

"""
Time Series Analysis in Spark SQL
Written JP Vijaykumar
Date Mar 8 2021

This script is provided for educational purpose only.
Pls modify/change the script as may be required to suit your environment.

I presented a script to process data using Time Series Analysis algorithm in sql and pl/sql earlier.
In this article, I am using the same code(90%) from my previous article and 10% pyspark code.

If you know sql, coding in pyspark is not that difficult.