A.2 Chapter 2, Oracle Architecture
Bigfiles
Bigfiles can hold up to 8 exabytes of data in a single file,
depending on the limitations of the underlying operating system.
Tablespaces support bigfiles, which eliminate the need for multiple
datafiles in a tablespace as a consequence of size limitations.
DROP DATABASE statement
Can be used to drop an entire database with a single statement.
Automatic archiving
The ALTER DATABASE ARCHIVELOG statement automatically marks redo logs
for archiving as they are filled, eliminating the need for the
LOG_ARCHIVE_START=TRUE initialization parameter.
Reduced configuration parameters
Oracle Database 10g reduces the number of
initialization parameters that require manual specification to fewer
than 40 parameters.