Orace Locking and Latching

What Are Locks?

Optimistic Locking Oracle Certification Exam TX (Transaction) Locks What Are Locks? With Bind Variables Without Bind Variables

  • Optimistic Locking Using a Version Column – Locking and Latching

    This is a simple implementation that involves adding a single column to each database table you wish to protect from lost updates. This column is…

    READ POST ➔

  • What Are Locks?- Locking and Latching-1

    Locks are mechanisms used to regulate concurrent access to a shared resource. Note how I used the term “shared resource” and not “database row.” It…

    READ POST ➔

  • Locking Issues – Locking and Latching

    Before we discuss the various types of locks that Oracle uses, it is useful to look at some locking issues, many of which arise from…

    READ POST ➔