Physical Data Storage
Oracle databases for both OLTP and DSS applications are implemented as a single data store; Oracle does not use a shared-nothing architecture. Tablespace files store database blocks (data, index, rollback segments, and temporary storage), and log information is held in redo log files. Status information about database files is held in control files. This section examines each of these file types.
Tablespaces
Data is held in tablespaces that span one or more data files. Tablespace data files can be either file system files or raw devices (that is, raw disk partitions or raw volumes created by a volume manager such as Solaris Volume Manager or Veritas). Raw devices typically offer better performance, although file system ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
