Optimize the Database with Oracle Architecture

Abstract

SQL and the relational model are logical constructs built on top of our slow, physical machines. Even E.F. Codd’s original paper warned that implementing the relational model would run into physical limitations. The more advanced features we use, and the more stress we put on the database, the more likely it is for Oracle’s abstractions to fail. Oracle has put a lot of effort into making our SQL code atomic, consistent, isolated, and durable. But no system can hide all of its implementation details, and we need to understand Oracle internals in order to make things work efficiently.