
Oracle FAQ blogs
2,098 FOLLOWERS
Home page of The Oracle Frequently Asked Questions Website. A valuable resource for all Oracle professionals!!! You may not get the Oracle company line, but you will surely get an answer to just about any question concerning the software giant and its products.
Oracle FAQ blogs
1y ago
articles:
SQL & PL/SQL
Hi Team,
Below we are using where exists clause taking much time.Is there a way to reduce the processing time.
UPDATE APP_CHATR.USAGE_DATA_ACCUMULATOR AA
SET AA.CUST_BAN_NO=(SELECT CUST_BAN_NO FROM
(
SELECT
/*+Leading(BAN_LOOKUP_WORK,USAGE_DATA_ACCUMULATOR)*/
X.CTN,
/*INDEX(APP_CHATR.USAGE_DATA_ACCUMULATOR X.CUST_BAN_NO)*/
X.CUST_BAN_NO
,( ROW_NUMBER() OVER (PARTITION BY X.CTN ORDER BY date_diff asc) ) QUALIFY
FROM
(
SELECT
A.CTN
,A.CUST_BAN_NO
,(B.SBSCRBR_START_DT- A.SBSCRBR_STAT_DT) date_diff
FROM
(Select * from APP_CHATR.BAN_LOOKUP_WORK
WHERE CUST_BAN_NO ..read more
Oracle FAQ blogs
1y ago
articles:
Developer
Do you want to explore the Oracle data dictionary with a network graph ?
There is a free web-based utility available for that purpose.
https://www.viskey4you.com ..read more
Oracle FAQ blogs
1y ago
articles:
Enterprise Manager
due to server maintenance, we had to stop our Oracle Middleware 12c application server. but startint the weblogic administration server is failing. Admin Server log reports this message
1. weblogic.security.SecurityInitializationException: Authentication denied: Boot identity not valid. The user name or password or both from the boot identity file (boot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot identity file with the proper values of username and password. The ..read more
Oracle FAQ blogs
2y ago
articles:
RDBMS Server
This is a short article about different enterprise license agreements that are available from Oracle.
Oracle Pool of Funds
- One time license fee - paid upfront.
- Oracle provides you with a highly discounted price list of selected products.
- You recieve flexibility that during the time period (1-3 years) choose
which Oracle products you wish to purchase.
- When the pool of funds have been burned down, the agreement ends.
There are some reporting requirements you need to be aware of.
Capped ULA
- This is often referred to as an Oracle ELA, but its Oracle ULA ag ..read more
Oracle FAQ blogs
2y ago
articles:
Java
Java licensing is still something that many organizations are struggling with.
We also see that Oracle is asking customers before they purchase licenses
that they are correctly licensed.
I want to write a easy guide for how to manage and review Java licensing.
There has been two major changes to Java licensing.
2019 Oracle made public updates not available to the public, that means
that customers who wants to have security updates for java 8 would
require to purchase a subscription / license from Oracle.
However, what most companies had overlooked is that Java has had a ..read more
Oracle FAQ blogs
2y ago
articles:
Technical Articles
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.
We use Oracle licensing on Azure, you must first purchase a new license ..read more
Oracle FAQ blogs
2y ago
articles:
Technical Articles
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 ULA is a enterprise software agreement from Oracle that gives the customer unlimited deployment rights
for a specific time period, usually 3 years. The customer negotiates a one-time license fee paid to Oracle
upfront as well as 12 months ..read more
Oracle FAQ blogs
2y ago
articles:
Technical Articles
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?
1. As soon as you recieve the Oracle license audit notification letter.
Contact an Independent Oracle license expert who can help you run ..read more
Oracle FAQ blogs
2y ago
articles:
SQL & PL/SQL
##############################################
#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.
Readers discretion/ingenuity is advised, in making necessary changes/modifications to these
scripts as may be required for thier use in their respective environments.
The user assumes full responsibility while executing these scripts.
Th ..read more
Oracle FAQ blogs
2y ago
articles:
RDBMS Server
DATA MIGRATION - USING - ASM DISK MIGRATION
--------------------------------------------
Author: JP Vijaykumar
Date: Jan 4th 2022
This article/script is provided for educational purpose ONLY.
Please understand the scripts, test thoroughly before use. Please modify the scripts as may be required,
and use the scripts at your own discretion.
Pls note, the number of exceptions mentioned here below are more than the sql queries provieded herewith.
That said, pls read the exceptions carefully and use the scripts judiciously.
EXCEPTIONS ..read more