Learn Something New About Alter Table Move
October 21, 2020Imagine that you have a large table, let’s say 500GB in size and 500 million rows in it. You need… Continue Reading
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
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
Things To Know About PGA_AGGREGATE_LIMIT
September 24, 2020This week I got a great surprise from one of my readers, Kaley. When I got my mail yesterday, there… Continue Reading
Scripts to Upgrade DB using Export/Import Datapump – Part 2
September 17, 2020Imagine upgrading your database with the export-import method, and getting hundreds of errors on the import. Why would that happen?… 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
Upgrade Your Database To 19c With Export-Import Datapump
August 26, 2020Upgrading the Oracle database to 19c is a very hot topic nowadays! I am not going to give you a… Continue Reading
Does SQLNET.ALLOWED_LOGON_VERSION_SERVER Parameter Affect the Password Version?
August 20, 2020That is a great question! But before answering it, let’s look at what the password version is, and what the… 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
Two Occupants That Affect The Most SYSAUX Tablespace Size
July 25, 2020Is you SYSAUX tablespace running out of space? Are you wondering what is causing the tablespace growth? Normally you would… Continue Reading