Blogs
Submitted by fredrikfilipsson on Wed, 2022-04-06 14:54
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?
Submitted by jp_vijaykumar on Tue, 2022-03-08 10:50
##############################################
#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.
Submitted by jp_vijaykumar on Tue, 2022-01-04 11:30
DATA MIGRATION - USING - ASM DISK MIGRATION
--------------------------------------------
Author: JP Vijaykumar
Date: Jan 4th 2022
Submitted by jp_vijaykumar on Tue, 2021-09-14 11:43
"""
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.
Submitted by John Watson on Mon, 2021-08-16 02:04
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.
Submitted by John Watson on Mon, 2021-07-05 07:29
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';
Submitted by jp_vijaykumar on Mon, 2021-03-08 15:10
"""
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.
Submitted by ashishkj on Tue, 2020-12-29 04:46
I want SQL queries for these two scenarios
Q. 1) Anagrams of a string i.e. let a name is RAMESH. So all combinations of letters of word RAMESH.
Probably a procedure needs to be written for this eg RAMESH, RHSEMA. There will be 6*5*4*3*2*1 combinations
Q.2 ) There is one table PERSON as follows:
Submitted by jp_vijaykumar on Mon, 2020-09-14 08:21
"""
Decision Tree Algorithm in Spark SQL
Written JP Vijaykumar
Date Sep 14 2020
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 decision tree algorithm using pl/sql earlier.
I like spark sql for the following reasons:
01) It is open source.
02) It combines the rich functionality of python and sql
03) It has the datamining libraries.
04) can be installed on my desktop and play around.
Submitted by John Watson on Fri, 2020-09-04 07:02
What block size should you use? For what purpose? How about tablespaces in different block sizes? Any opinions?
Pages
|
