The curious case of enq: TX – row lock contention
After migrating the test database to Oracle Exadata Cloud at Customer, the customer wanted to send us to the cloud… The performance was awful. Really – like 7 times slower. But funny story – not from AWR perspective. From AWR perspective everything was pitchy. Almost every SQL was faster but one – a very small UPDATE. This is a story of poorly written applications and a small infrastructure issue. We will dig a bit into TNS protocol, but just a bit – not more than needed. BTW – I’ll tell you a bit about Exadata Cloud at Customer gen. 1.