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

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

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

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

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

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

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

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

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

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