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
The place where DBAs grow
I hope all of you had a great winter break! Did you spent some time learning something new? I, personally… Continue Reading
In my last blog post I introduced you to Online Stats and Real Time Stats.Today I will show you, in… Continue Reading
Can an inactive sessions block other sessions? Can a session that shows no SQL_ID in v$session, block other sessions? YES!… Continue Reading
Imagine that you have a large table, let’s say 500GB in size and 500 million rows in it. You need… Continue Reading
Have you ever wondered why I created The Ultimate SQL Tuning Formula? At the beginning of my career, I remember… Continue Reading
In my last blog post, I was showing you one way to upgrade a database to 19c (or to any… Continue Reading
That is a great question! But before answering it, let’s look at what the password version is, and what the… Continue Reading
Ever wondered how to check what patches are installed for a database home, without actually having access to the database… Continue Reading
Is you SYSAUX tablespace running out of space? Are you wondering what is causing the tablespace growth? Normally you would… Continue Reading