Database Reference
In-Depth Information
Physical & Logical Architecture Relationship
Figure 3-5 gives a side by side relationship between logical and
physical architecture of Oracle database. The database is the
same but you can look at it through two angles. You can talk
about its files (data files, control file etc.) or you can talk about
its tablespaces, segments (objects) etc.
Figure 3-5: Relationship between Physical and Logical architecture of
Oracle database. Tablespace is a name/alias given to a group of one or
more data files. Data inside the tablespace reside in the data files which
are physical files like all other files located on your computer. Size of
the tablespace and hence the size of database is not limited to the OS
marked limit on the file size.
Tablespaces are like small departmental level databases within a
bigger umbrella of company's database. Data inside these
tablespaces within the database resides in the data a file. You
insert data into the segments (tables) using INSERT statement so
the segment grows. When the segment grows, tablespace within
which its residing grows and the size of data file(s) associated
with the tablespace grows. If there is only one data file
associated with the tablespace then the maximum size of the
tablespace cannot be more than the Operating System maximum
 
Search WWH ::




Custom Search