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.