How Many Processes In the Database Historically?
March 23, 2023The other day, I had an interesting challenge to look at. The maximum number of processes in the database instance… Continue Reading
Tag: DBA
4 Ways of Connecting to a PDB
February 26, 2023How do I connect to a PDB? This is a common question among new DBAs, and a valid one indeed!We… Continue Reading
SQLPLUS’ Forgotten Option: COLSEP
January 19, 2023Today’s blog post came to my mind, as I am re-writing some scripts, written by others, with tones of concatenations… Continue Reading
What Is the Become User Privilege
October 12, 2022You might be learning something new today, as I did when I ran the DBSAT Oracle utility! In the generated… Continue Reading
Do You Know How To TRIM or PAD Character Strings?
September 12, 2022Continuing on the blog post series of Single-Row Character Functions, we are going to discuss and learn about the following… Continue Reading
How To Use Character Functions That Manipulate The Case
September 1, 2022In the single-row functions series, we are going to talk about Character Functions, the ones that manipulate the case. Because… Continue Reading
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
What Are Single Row Functions
June 20, 2022Do you remember what the two main categories of built-in functions are in Oracle? These categories are created based on… Continue Reading
What Is Deferred Segment Creation?
April 11, 2022Did you know that deferred segment creation was introduced in 11.2? Some DBAs might not be familiar with this concept… Continue Reading
How To Get Historical Row Count In a Table?
March 12, 2022Have you been in a situation where you had to prove the row count in a table has changed or… Continue Reading