Oracle RDBMS Logical Structure - Storage

in #technology7 years ago (edited)

startr.jpg

Hi, this is Oracle Girl. In the previous lesson we learned about the relational database and how the object structures are related. In today’s lecture we will see how those relationships are represented in Oracle RDBMS. The Oracle Database architecture consists of three major components: memory, processes, and storage. We will have a look at the storage logical structures.

snap (5).jpg

The smallest unit of storage in Oracle is block. It consists of one ore more operating system blocks. The proper size of it, is decided during database creation. This parameter cannot be modified afterwards.

snap (6).jpg

The next level of logical grouping is called extent. It is a group of continuous blocks, allocated in one chunk.

snap (7).jpg

Set of extents makes up a Segment – the next level of logical storage structure.

snap (8).jpg

Whenever you create a logical structure that stores data such as table, Oracle allocates a segment, which contains at least one extent.

snap (9).jpg

The segments are grouped in the highest level of logical structures called tablespace. The tablespaces have a direct relationship to the physical structure of the database – datafile. We will discuss the physical structure in our next lesson.

snap (10).jpg

Let’s summarize. Looking at the logical structure of the database, a tablespace is the highest level of logical unit. A tablespace consists of several segments. A segment consists of one or more extents and can be associated to only one tablespace. An extent is a contiguous allocation of blocks. A block is the smallest unit of storage in an Oracle database.

snap (11).jpg

Thank you for your participation in today’s lesson. Please let me know if you have questions or recommendations in the comment section below.

snap (12).jpg

You can see this as video lesson @dlive.

resources:
OCA: Oracle Database 12c Administrator Certified Associate Study Guide, Sybex
Official Oracle Documentation @docs.oracle.com

Talk to you soon, Oracle Girl

Capture.JPG

Sort:  

Congratulations @oraclegirl! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 1 year!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Vote for @Steemitboard as a witness to get one more award and increased upvotes!

Coin Marketplace

STEEM 0.20
TRX 0.25
JST 0.038
BTC 97467.82
ETH 3388.58
USDT 1.00
SBD 3.13