Database Management & Programming News, Articles & Tutorials for Database Administrators

Delaying Standby Database Recovery 06/10/2021

Does it ever make sense to delay database recovery from your Standby? With the right DB recovery strategy in place, delays might be your best move.

What Backups Do I Have? 05/12/2021

As a DBA you need to check periodically to make sure you have backups.  I would recommend you do this daily.

Tip 75 - Improving the Performance of a Table Variable using Optimizer Hint RECOMPILE 04/01/2021

To improve the performance of your code that uses numerous table variables, consider adding the optimizer hint RECOMPILE.

TYPE Definition Change in Oracle 21c 03/04/2021

Oracle 21c now offers the possibility of using some PL/SQL data types in SQL*PLus, with some restrictions.  Read on to see what types are available and how to use them.

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).

Tip 74 – Changing Cost Threshold for Parallelism 02/24/2021

Anytime the optimizer calculates a plan that exceeds a given threshold, the optimizer will consider using plans that will go parallel.

Overview: Six Backup Options for SAP HANA on Azure VMs 02/25/2021

You've got a number of options open to you to perform backups of SAP HANA running in Azure virtual machines (VMs).