In a database there is always the possibility of corruption. This can be either physical e.g. from some disk damage or either logical e.g. wrong values in a table field. In the article we will see how… read more
How can we get emails whenever we have high CPU Usage in SQL Server
In this article we will see a script that creates a SQL Server Agent Job that will notify us by email whenever the CPU exceeds a threshold. It derives the information not from performance counters of the operating system but... read more
Useful commands to manage Oracle Grid Infrastructure / RAC (crsctl / srvctl)
In this article we will see some useful commands to manage databases installed on Oracle Grid Infrastructure. We manage Oracle Cluster Resources (CRS) through the CRSCTL tool and Oracle Database , Listener and… read more
How do we limit the resources that a user can consume in SQL Server
Many times a user in the database can consume all the resources that the SQL Server instance has and no other work can be done by another user. In this article we will see how we can… read more
A disk is full of SQL Server datafiles, what should I do?
Sometimes a disk will suddenly become full. On this disk we may have one base or many, while we may have space on another disk, we must somehow find which datafiles are full. In this… read more
How to install Enterprise Manager Cloud Control for Oracle database monitoring and administration
In this article we will see how to install Oracle Enterprise Manager Cloud Control on Oracle Linux / Red Hat Linux step by step. This tool provides the ability to manage Oracle databases through… read more
Why can't I shrink the transaction log in SQL Server and why is it full?
In a previous article we saw what the Transaction Log is. This time we'll see how we can empty it and make it shrink, we'll also see what we can do case by case when it won't let us. Suddenly… read more
How to install an Oracle Real Application Cluster (RAC) on Linux using Direct NFS
In this article we will see step by step how to install an Oracle Database belonging to a Real Application Cluster (RAC) on a Linux operating system (Oracle Linux 7.7) with shared NFS disks without using Oracle ASM (Automatic Storage... read more
How to enable Oracle Direct NFS for increased performance between Oracle Database and NFS Shares
In this article we will see how to enable Direct NFS for Oracle Database connectivity with NFS Servers. When we enable it the communication between Oracle Database and NFS Servers is done directly, without involving the kernel of… read more
