Creating PDBs By Cloning
January 25, 2021Last post we learned to create PDBs from scratch. This week we will look at creating PDBs by cloning other… Continue Reading
How To Create A PDB From Scratch
January 12, 2021Did you read my last post about the Multitenant Architecture? Today, we are going to go a bit deeper and… Continue Reading
Intro To Multitenant Architecture
January 2, 2021I hope all of you had a great winter break! Did you spent some time learning something new? I, personally… Continue Reading
Real-time Stats in Action
December 18, 2020The last 2 articles I wrote covered the online stats vs real-time stats at a higher level, and then I… Continue Reading
Online Stats in Action
November 26, 2020In my last blog post I introduced you to Online Stats and Real Time Stats.Today I will show you, in… Continue Reading
Online Stats vs Real-time Stats
November 12, 2020Are you aware of these new terminologies, real-time stats and online stats? Or are these new to you? Maybe you… Continue Reading
Can an inactive session block other sessions?
November 3, 2020Can an inactive sessions block other sessions? Can a session that shows no SQL_ID in v$session, block other sessions? YES!… Continue Reading
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