How Can NLS_DATE_FORMAT Help You?
January 12, 2022When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of… Continue Reading
Tag: DBA
What Is Oracle Instance Recovery?
January 6, 2022Oracle instance recovery occurs automatically when you try to startup and open a database that crashed or was shutdown abort.… Continue Reading
How To Synchronize Applications
September 27, 2021In previous blog post we talked about maintenance in the application root container. If you remember, I mentioned that the… Continue Reading
Application Upgrade inside the Application Root Container
August 2, 2021In the previous post, we talked about application maintenance within an Application Root Container, specifically an application installation. As promised,… Continue Reading
When to use MAX_PDBS parameter
March 16, 2021MAX_PDBS parameter was introduced in 12cR2, to limit the number of pluggable databases (PDBs) one can create in a CDB… Continue Reading
FILE_NAME_CONVERT vs PDB_FILE_NAME_CONVERT
March 3, 2021After last week’s post, I got some feedback from you, my subscribers and readers, and you asked me to elaborate… Continue Reading
What Is A Refreshable Clone PDB?
February 20, 2021Did you know you can create a Clone PDB, that can be refreshed at a later time with new data… Continue Reading
What Is Local Undo Mode
January 31, 2021Since I mentioned local undo mode in my previous posts, lots of you asked me to elaborate on it, and… Continue Reading
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
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