DBA Paradise

Meet Your New Friend: DBMS_SPACE.SHRINK_TABLESPACE

By dianarobete September 30, 2024 Off

How many times did you try to resize your tablespace or datafile and got the error “ORA-03297: file contains used… Continue Reading

By dianarobete May 20, 2024 Off

Another 23c or 23ai feature that you will be happy embracing!In previous Oracle versions, what did you do when someone… Continue Reading

By dianarobete May 12, 2024 Off

A new feature was introduced with 23c, now 23ai, that can help you with object creation or object drop. This… Continue Reading

By dianarobete January 31, 2024 Off

You read that right! One of the best features of Oracle 23c is the use of aliases in the GROUP… Continue Reading

By dianarobete December 15, 2023 Off

Did you know that starting with Oracle 23c, the FROM clause is optional? Not totally optional, so let me explain.… Continue Reading

By dianarobete November 26, 2023 Off

One of the new features of the Oracle 23c is annotations. These were mostly created for developers, but I can… Continue Reading

By dianarobete March 28, 2023 Off

It’s spring time, and that comes with spring cleaning not only your house and closets, but your databases too! What… Continue Reading

By dianarobete March 23, 2023 Off

The other day, I had an interesting challenge to look at. The maximum number of processes in the database instance… Continue Reading

By dianarobete February 26, 2023 Off

How do I connect to a PDB? This is a common question among new DBAs, and a valid one indeed!We… Continue Reading

By dianarobete January 19, 2023 Off

Today’s blog post came to my mind, as I am re-writing some scripts, written by others, with tones of concatenations… Continue Reading