From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Oracle logical architecture

Oracle logical architecture - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Oracle logical architecture

“

- [Instructor] Now that we've come to understand all that is involved in the physical architecture, it's time to step into the logical side of the storage. Logically, Oracle storage is broken down into four areas ranging from the smallest to the largest, blocks, extents, segments, and tablespaces. The smallest unit of IO in the Oracle database is called the block. A block size is set at the time of the database creation and is different from the measurement of IO at the operating system level, which is measured in bytes. The default block size for Oracle is eight kilobytes, and although rare these days and dependent upon the use case, the block size could be larger. No matter the use of the data block, the format is the same. There is a header, a table directory, a row directory, defined free space, and then the row data. The next logical storage measurement is an extent, which is a collection of database blocks allocated to a set of information belonging together. A segment is an…

Contents