Kellyn Pot'Vin-Gorman in Oracle Oracle’s Limited Cloud Vendor Licensing It’s nothing new for vendors to find ways to lock in customers to their products and cloud services. Oracle recently... 15 April 2025 3 min read
Kellyn Pot'Vin-Gorman What is Oracle RAC and Why Use it for Scaling Workloads? Oracle Real Application Clusters (RAC) is a database clustering solution that enables multiple servers to operate as a single, unified... 10 February 2025 6 min read
Kellyn Pot'Vin-Gorman in Oracle Oracle Architecture Overview I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways are best, but... 02 January 2025 24 min read
Kellyn Pot'Vin-Gorman in Oracle Introduction to Oracle Database for Database Professionals Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used relational database management... 05 December 2024 12 min read
Oracle Chandra Rawat in Oracle A Guide to INSERT, UPDATE, and DELETE Statements in Oracle In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE.... 09 June 2023 19 min read
Oracle Chandra Rawat in Oracle The SELECT Statement in Oracle The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular... 16 March 2023 19 min read
Oracle Jonathan Lewis in Oracle Oracle optimizer Or Expansion Transformations The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some... 26 October 2022 15 min read
Oracle Jonathan Lewis in Oracle Oracle optimizer removing or coalescing subqueries The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations... 27 April 2022 17 min read
Oracle Samuel Nitsche in Oracle Why your PL/SQL needs to be testable – and how to do it: Part 1 Part 1: What is testable code, why is it important, and first glimpses on practices that can help Anyone familiar... 05 April 2022 15 min read
Oracle Jonathan Lewis in Oracle Oracle subquery caching and subquery pushing In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how... 18 March 2022 12 min read
Oracle Jonathan Lewis in Oracle The effects of NULL with NOT IN on Oracle transformations IN and NOT IN subqueries are frequently used in Oracle. Jonathan Lewis explains how the optimizer handles NULL with IN... 22 February 2022 11 min read
Oracle Jonathan Lewis in Oracle Transformations by the Oracle Optimizer To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several... 14 January 2022 16 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Oracle Text Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in... 30 August 2021 12 min read
Oracle Jonathan Lewis in Oracle Oracle sequences – 12c features including “identity” Oracle added several enhancements to the sequence object in version 12c, including an “identity” column feature. Jonathan Lewis explains how... 19 August 2021 16 min read
Oracle Jonathan Lewis in Oracle Typical uses of Oracle sequences Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical... 14 July 2021 17 min read
Oracle Jonathan Lewis in Oracle Oracle Sequences: RAC Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how... 11 May 2021 19 min read
Oracle Jonathan Lewis in Oracle Oracle sequences: The basics Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they... 26 March 2021 14 min read
Oracle Jonathan Lewis in Oracle Oracle archived redo size – the research Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes... 11 January 2021 15 min read
Oracle Jonathan Lewis in Oracle Are your Oracle archived log files much too small? Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs.... 30 November 2020 12 min read
Oracle Srinivasan Suresh in Oracle SQL Developer – A great tool and better ways to use it SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features... 19 November 2020 14 min read
