About Database Storage Structures

About Database Storage Structures
An Oracle database is made up of physical and logical structures. Physical structures
can be seen and operated on from the operating system, such as the physical files that
store data on a disk.
Logical structures are created and recognized by Oracle Database and are not known
to the operating system. The primary logical structure in a database, a tablespace,
contains physical files. The applications developer or user may be aware of the logical
structure, but is not usually aware of this physical structure. The database
administrator (DBA) must understand the relationship between the physical and
logical structures of a database.
Figure 6-1 on page 6-2 shows the relationships between logical and physical
structures. This figure also shows recovery-related structures that are optionally kept
in the fast recovery area. See "Fast Recovery Area" on page 9-5 for more information.
... zobacz całą notatkę