Skip to main content

Optimize the Database with Oracle Architecture

  • 697 Accesses


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.

This is a preview of subscription content, log in via an institution.

Buying options

USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
USD   49.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   64.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions


  1. 1.

    DBA_TAB_COLS shows the system-generated columns, whereas the data dictionary view DBA_TAB_COLUMNS only shows the user-generated columns.

  2. 2.

    In PostgreSQL, the changes are stored within the tables. That approach has advantages, but it requires periodically vacuuming tables to reclaim space.

Author information

Authors and Affiliations


Rights and permissions

Reprints and permissions

Copyright information

© 2023 The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Heller, J. (2023). Optimize the Database with Oracle Architecture. In: Pro Oracle SQL Development . Apress, Berkeley, CA.

Download citation

Publish with us

Policies and ethics