5 Best Paid and Free IPAM Software

As businesses become bigger, the number of devices on the network can explode, rapidly becoming a headache for anyone trying to manage the associated IP addresses. For a small business, it might be feasible for the network admin to manage IP addresses and network information manually using spreadsheets. But for larger enterprises, IP address management … Read more 5 Best Paid and Free IPAM Software

7 Best Splashtop Alternatives for 2022

There are several remote desktop tools available on the market today, which can make it difficult to choose the one best suited to your company’s individual needs. Although Splashtop is a very popular remote access tool with a global customer base, it isn’t a one-size-fits-all solution and you may find another tool is better able … Read more 7 Best Splashtop Alternatives for 2022

Oracle Log File Sync Wait Event

The Oracle “log file sync” wait event is triggered when a user session issues a commit (or a rollback). The user session will signal or post the LGWR to write the log buffer to the redo log file. When the LGWR has finished writing, it will post the user session. The wait is entirely dependent … Read more Oracle Log File Sync Wait Event

Oracle Cache Buffers Chain Latch

A user process acquires the CACHE BUFFERS CHAINS latch to scan the System Global Area (SGA) for database cache buffers. Blocks in the buffer cache are placed on linked lists (cache buffer chains). Blocks are put on the hash chain according to their DBA (data block address) and CLASS of the block. Each hash chain … Read more Oracle Cache Buffers Chain Latch

Solving Oracle enq: TM Contention Wait Events

Recently, I was assisting one of our customers for Oracle trying to diagnose sessions waiting on the “enq: TM – contention” event. The blocked sessions were executing simple INSERT statements similar to: INSERT INTO supplier VALUES (:1, :2, :3); Waits on enq: TM – contention indicate there are unindexed foreign key constraints. Reviewing the SUPPLIER … Read more Solving Oracle enq: TM Contention Wait Events