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…
database advise, step by step guides, how to emails
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…