Oracle – PL/SQL – Using ROW/TABLE Locks To Implement Application/Job Semaphore To Handle Race Conditions

What is a Semaphore? Instead of a clinical illustration of exclusive row lock and exclusive table lock usage in Oracle, here we will try to use them to highlight a higher level concept – Implement a semaphore mechanism. Wikipedia defines semaphore as below: In computer science, a semaphore is a variable or abstract data type … Continue reading Oracle – PL/SQL – Using ROW/TABLE Locks To Implement Application/Job Semaphore To Handle Race Conditions

Advertisements

Wait & Notify via email When A Process Completes – Using PowerShell

A colleague of mine was copying a large file over the network using "RoboCopy". As a good citizen, he throttled the copy using the "/IPG" switch of RoboCopy. For information sake, /ipg:n Specifies the inter-packet gap to free bandwidth on slow lines. After starting the copy he informed me that it would complete in around … Continue reading Wait & Notify via email When A Process Completes – Using PowerShell