Useful Examples For DBAs of Single Row Numeric Functions
August 26, 2022In the previous post, we started talking about Single Row Functions, which return a single value (row) for each row… Continue Reading
The place where DBAs grow
In the previous post, we started talking about Single Row Functions, which return a single value (row) for each row… Continue Reading
Do you remember what the two main categories of built-in functions are in Oracle? These categories are created based on… Continue Reading
Did you know that deferred segment creation was introduced in 11.2? Some DBAs might not be familiar with this concept… Continue Reading
Have you been in a situation where you had to prove the row count in a table has changed or… Continue Reading
When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of… Continue Reading
Oracle instance recovery occurs automatically when you try to startup and open a database that crashed or was shutdown abort.… Continue Reading
In previous blog post we talked about maintenance in the application root container. If you remember, I mentioned that the… Continue Reading
In the previous post, we talked about application maintenance within an Application Root Container, specifically an application installation. As promised,… Continue Reading
MAX_PDBS parameter was introduced in 12cR2, to limit the number of pluggable databases (PDBs) one can create in a CDB… Continue Reading
After last week’s post, I got some feedback from you, my subscribers and readers, and you asked me to elaborate… Continue Reading