When an Oracle database is heavily used by many connections / sessions, one or some of them may consume a large percentage of memory (RAM). If there is a problem and it is not addressed due to lack of memory it may… read more
How can we get emails whenever syncing to SQL Server via Oracle GoldenGate is having problem
When we synchronize tables through Oracle GoldenGate, it can either stop the extract of the source from writing trail files to the target in the tables, or stop the replicat of the target from applying the trail files. So for any… read more
How can we get email whenever synchronization between databases is lost in Oracle Data Guard
In this article we will see how we make a mechanism that will inform us by email when some of the standby databases that synchronize with the primary have fallen behind in the sequence number of the logs or because... 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
How can we get email whenever an error occurs in SQL Server Error Log
In an instance of SQL Server, potential problems that occur are recorded in a place called the Error Log. However, it would be very useful for us if any important error appeared in the Error Log, SQL Server forwarded it to us... read more
How can we get email whenever we have blocking session in Oracle database
In an Oracle database, every time a session updates the elements of a table, it becomes locked to ensure that no other session will be able to modify the same table at the same time. But when… read more
How we send email through SQL Server
Through Microsoft SQL Server we have the possibility to send emails either for some alerting or so that we can send reports. In this article we will see step by step how it works and how to activate Database Mail... read more
How can we get an email whenever an error occurs in the Oracle database Alert log
In a system based on an Oracle database, that an error occurs is recorded in a log file called the Alert Log. It is very useful to be informed immediately when something happens and the most immediate way is no other… read more
