19c LISTAGG Can Do Distinct
October 15, 2020Do you use analytic functions in Oracle? I do not use them as much as I’d like to, but I… Continue Reading
Tag: DBA
The Story Behind The Ultimate SQL Tuning Formula
September 28, 2020Have you ever wondered why I created The Ultimate SQL Tuning Formula? At the beginning of my career, I remember… Continue Reading
Scripts to Upgrade DB using Export/Import Datapump – Part 1
September 8, 2020In my last blog post, I was showing you one way to upgrade a database to 19c (or to any… Continue Reading
DBMS_QOPATCH How to List the Patches Applied Without Connecting to the Database Server
August 3, 2020Ever wondered how to check what patches are installed for a database home, without actually having access to the database… Continue Reading
Quick and Easy Steps To Change Database Name
April 24, 2020When was the last time you had to change the name of a database? Long time ago, changing the database… Continue Reading
SQL Quarantine In Action On Your Laptop
February 14, 2020Last week I gave you a taste for SQL Quarantine. Some of you asked me if I know when this… Continue Reading
Intro To SQL Quarantine
February 6, 2020In the last blog post we talked about Quarantined Objects, which have no relationship whatsoever with today’s topic. I just… Continue Reading
Background Processes Makeover
December 19, 2019It is worth going back to the basics, when you learn a new version of the database. Oracle’s background processes… Continue Reading
Install 19c On Windows
November 20, 2019In the last post, I have asked you if you wanted to learn 19c with me. The response has been… Continue Reading
Learn 19c With Me
November 7, 2019Let’s take the 19c learning seriously. Who’s with me? Do you keep postponing learning something new? Do you feel like… Continue Reading