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
Tag: DBA
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
CPU_COUNT Parameter And Instance Caging
October 31, 2019Have you wondered how many CPUs are allocated to your database? One of my reader has, and he asked me… Continue Reading
Fix ORA-04095: Trigger Already Exists On Another Table
September 10, 2019One of my readers asked me what is the cause of the following error, and what is the work around… Continue Reading
What To Do When The Export Fails With ORA-01466?
August 7, 2019The nightly backup job you have scheduled for your database, the datapump export job, starts failing with the following error:… Continue Reading