locking

Understanding how oracle internally manages the transactions is very crucial for your applications. Dealing with the database as a black box (sending queries and receiving results), will end up with bad performance to your application or/and non-scalable application. Oracle uses locks to internally manages the concurrent access to data.Only one transaction can modify any piece … Continue reading Oracle Database Locking Policy – Back to Basics