How To Use LISTAGG To Create Awesome DBA Reports
Published: Thu, 10/05/17
Do you want to write some kick ass reports? Convert some rows into lines very quickly and easily?orDo you want to be stuck with the SQL statements you…
Diana Robete
database advise, step by step guides, how to emails
2 Useful Things To Know About SQL Plan Baselines
Published: Thu, 09/28/17
Last two weeks, we covered the building blocks of SQL Plan Management, and then we got started with SQL Plan Baselines!What’s ne t?, you might be…
One Easy Step To Get Started With SQL Plan Baselines
Published: Thu, 09/21/17
If you wonder how SQL Plan Baselines work, then this post is for you!If you want to get started with SQL Plan Baselines, but don’t know how, this post…
Building Blocks Of SQL Plan Management 12c
Published: Fri, 09/15/17
Ever found yourself in a situation when you had to pretend you understand and know everything that is going on in a conversation about some database…
How To Make login.sql Work Again In 12.2 and 11.2.0.4
Published: Thu, 08/31/17
What happens when things change and all of a sudden don’t work the same as they used to?Do you get annoyed? Do you start trying to find who’s fault it…
How To Make login.sql Work Again In 12.2 and 11.2.0.4
Published: Thu, 08/31/17
se that was patched, same behavior. All you see isSQL> This time you try a database tWhat happens when things change and all of a sudden don’t work…
Strong vs Weak Selectivity – Everything A DBA Needs To Know
Published: Thu, 08/24/17
Previous post I introduced you to Selectivity and Cardinality, and asked a question at the end.Thanks to all the readers that responded! You are…
5 Things To Better Understand Selectivity And Cardinality
Published: Thu, 08/10/17
If you really want to confuse a candidate for a DBA job interview, just ask the question:“Can you e plain to me the difference between selectivity and…
OUI and OPatch What Are They Used For?
Published: Fri, 08/04/17
The last two weeks I’ve been talking about the Central Oracle Inventory and the Local Oracle Inventory.I have mentioned two Oracle tools that are…
All You Need To Know About The Local Oracle Inventory
Published: Thu, 07/27/17
Most DBAs have heard of the Central Oracle Inventory, even if they don’t know details about it.But, have you heard of the Local Oracle Inventory?If…