5 Steps To Automate Listen.log Mining
Published: Fri, 02/01/19
If you read last week’s article, then you most likely understand the importance and the benefit of reviewing the listener.log files in your…
Diana Robete
database advise, step by step guides, how to emails
5 Reasons You Should Review The listener.log File
Published: Wed, 01/23/19
Many years ago, I found an article written by Arup Nanda, on mining the listener log file. If you have not read it, I encourage you to do it, you can…
How To Setup Externally Authenticated Users in A Multitenant Database
Published: Thu, 01/10/19
It is not very often that a DBA creates e ternally authenticated users. Creating such users in a multitenant database, needs some e tra steps. When I…
New Year, New Skills To Learn
Published: Fri, 01/04/19
A new year has begun, and so did a new chapter of your career. What are you going to write in this chapter? The Christmas rush is gone. All the time…
Cheat Sheet For Common And Local Users, Roles, Profiles
Published: Tue, 12/18/18
When you transition from a single instance, non-CDB database to a multitenant database architecture, working with users, roles and profiles might get…
4 Things You Need To Know About Database Restricted Mode
Published: Fri, 11/16/18
For certain database operations, you need to place your database in restricted mode.There are two ways to proceed to accomplish this task, and I will…
How To Display Dates Relative To Current Day
Published: Thu, 11/08/18
It doesn’t happen very often that DBAs need to write reports based on dates, but when they do, they might need all kind of funky dates to use, that…
5 Things To Know About Chained And Migrated Rows
Published: Thu, 10/25/18
We hear it all the time that chained or migrated rows are not good. But if someone would challenge you to e plain it why, could you do it?Many times…
Who Is Holding The Lock On The Table?
Published: Thu, 10/11/18
Did you ever get an email or a phone call from a developer telling you they are getting an error when trying to drop a table? It sounds something like…
What Can You Use DBMS_UTILITY.EXPAND_SQL_TEXT For?
Published: Thu, 10/04/18
Have you ever worked through a tuning e ercise (I’d like to call them e ercises instead of problems), where the SQL Statement looked very simple,…