Oracle Locking Mechanism – Latches & Enqueues

This article is part of Oracle Performance Tuning Series and is created to describe Oracle’s locking mechanism. A lock is a resource that you need to hold to get access to the resource. Oracle has two kind of locks: enqueues and latches, we would now focus on these locking mechanism individually. Enqueues Enqueues are sophisticated…

Queries to Monitor Oracle Sessions

This post is to provide a set of queries to monitor any user session on an Oracle Instance more efficiently. Below query (Lets name it Query1 for the sake of discussion) gives you an overall status of what all sessions are active, what wait event they are waiting on and what are they executing. set…