database advise, step by step guides, how to emails
Published: Tue, 10/01/24
Updated: Tue, 10/01/24
Meet Your New Friend: DBMS_SPACE.SHRINK_TABLESPACE How many times did you try to resize your tablespace or datafile and got the error “ORA-03297: file…
Published: Sun, 05/12/24
Updated: Sun, 05/12/24
23ai New feature: How To Use IF [NOT] EXISTS in DDL StatementsA new feature was introduced with 23c, now 23ai, that can help you with object creation…
Published: Wed, 01/31/24
23c New Feature – Alias in the GROUP BY Clause? You read that right! One of the best features of Oracle 23c is the use of aliases in the GROUP BY…
Published: Fri, 12/15/23
Is the FROM Clause Really Optional? Did you know that starting with Oracle 23c, the FROM clause is optional? Not totally optional, so let me e plain.
Published: Sun, 11/26/23
What Are Annotations and How to Use Them in Oracle 23c?One of the new features of the Oracle 23c is annotations. These were mostly created for…
Published: Tue, 03/28/23
4 Steps to Spring Clean Your DatabasesIt’s spring time, and that comes with spring cleaning not only your house and closets, but your databases too!…
Published: Thu, 03/23/23
How Many Processes In the Database Historically?The other day, I had an interesting challenge to look at. The ma imum number of processes in the…
Published: Sun, 02/26/23
How do I connect to a PDB? This is a common question among new DBAs, and a valid one indeed!We are all used to connect to a database with the “/ as…
Published: Fri, 01/20/23
Today’s blog post came to my mind, as I am re-writing some scripts, written by others, with tones of concatenations of commas, to obtain a csv file. I…
Published: Wed, 10/12/22
You might be learning something new today, as I did when I ran the DBSAT Oracle utility! In the generated report, I noticed a privilege that was…