{"id":3708,"date":"2025-05-29T16:57:40","date_gmt":"2025-05-29T16:57:40","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&p=3708"},"modified":"2025-05-29T16:57:41","modified_gmt":"2025-05-29T16:57:41","slug":"database-storage-structures","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/getting-started-with-oracle-dba\/database-storage-structures\/","title":{"rendered":"Database Storage Structures"},"content":{"rendered":"\n

\ud83e\udde0 Introduction<\/strong>
Ever wondered how Oracle actually stores your data<\/strong>?<\/p>\n\n\n\n

Let\u2019s break it down \u2014 from big-picture storage like tablespaces, down to the tiniest data block.<\/p>\n\n\n\n

Whether you’re using a CDB (Container Database)<\/strong> or PDB (Pluggable Database)<\/strong>, these layers apply.<\/p>\n\n\n\n

\ud83e\uddf1 Storage: Two Levels \u2013 Physical and Logical<\/strong><\/p>\n\n\n\n

\ud83d\udd39 Physical Level<\/strong> \u2013 Where data is actually<\/em> stored (on disk)
\ud83d\udd39 Logical Level<\/strong> \u2013 How Oracle organizes<\/em> and manages<\/em> that storage<\/p>\n\n\n\n

Let\u2019s look at each in detail \u2b07\ufe0f<\/p>\n\n\n\n

\ud83d\uddc2\ufe0f \ud83d\udd38 Physical Storage Options<\/strong><\/p>\n\n\n\n

Oracle can store data files using three main mechanisms:<\/p>\n\n\n\n

    \n
  1. File System<\/strong>
    \u27a4 Traditional OS-based file structure
    \u27a4 Most Oracle DBs use this by default<\/li>\n\n\n\n
  2. Cluster File System<\/strong>
    \u27a4 Used in Oracle RAC (Real Application Clusters)<\/strong>
    \u27a4 Makes shared storage look like a single file system
    \u27a4 Multiple servers can access the same data<\/li>\n\n\n\n
  3. Oracle ASM (Automatic Storage Management)<\/strong>
    \u27a4 Oracle-managed storage
    \u27a4 Provides performance + reliability
    \u27a4 Reduces manual storage management<\/li>\n<\/ol>\n\n\n\n

    \ud83d\udccc Data files<\/strong> = The actual files that store your tables, indexes, etc.<\/p>\n\n\n\n

    \ud83e\udde0 \ud83d\udd39 Logical Storage Structures (Inside Oracle)<\/strong><\/p>\n\n\n\n

    Layer<\/th>Description<\/th><\/tr><\/thead>
    Tablespace<\/strong><\/td>A logical container for data. Can hold multiple segments. Each PDB<\/strong> has its own set of tablespaces.<\/td><\/tr>
    Segment<\/strong><\/td>Set of extents<\/strong> used by a schema object (like a table or index). One object = one segment.<\/td><\/tr>
    Extent<\/strong><\/td>Set of contiguous data blocks<\/strong>. More extents are added as needed.<\/td><\/tr>
    Data Block<\/strong><\/td>Smallest unit of logical storage. Usually 2KB, 4KB, 8KB, etc. Stored in data files.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    \ud83d\udd01 Flow of Storage:<\/strong><\/p>\n\n\n\n

    Tablespace \u2192 Segment \u2192 Extent \u2192 Data Block \u2192 Data File<\/code><\/code><\/pre>\n\n\n\n
    \ud83d\udce6 Tablespaces in Detail<\/strong><\/p>\n\n\n\n
    \u2705 USERS<\/strong> tablespace
    \u27a4 Default location for user data<\/p>\n\n\n\n
    \u2705 Custom Tablespaces
    \u27a4 Can be created for separating system data, app-specific data, etc.<\/p>\n\n\n\n
    \ud83d\udccc One tablespace = many data files<\/strong>
    \ud83d\udccc One data file = belongs to one tablespace only<\/strong><\/p>\n\n\n\n
    \ud83d\udee0\ufe0f DBA Tip of the Day<\/strong>
    Understanding how Oracle organizes storage helps you optimize performance<\/strong> and space usage<\/strong>.<\/p>\n\n\n\n
    When things go wrong \u2014 like fragmentation or storage alerts \u2014 this is where you start debugging.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \ud83e\udde0 IntroductionEver wondered how Oracle actually stores your data? Let\u2019s break it down \u2014 from big-picture storage like tablespaces, down to the tiniest data block. Whether you’re using a CDB (Container Database) or PDB (Pluggable Database), these layers apply. \ud83e\uddf1 Storage: Two Levels \u2013 Physical and Logical \ud83d\udd39 Physical Level \u2013 Where data is actually […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[960,952],"class_list":["post-3708","cposts","type-cposts","status-publish","hentry","category-getting-started-with-oracle-dba","category-notes"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}