Some items that can be configured in an Oracle database are the following:
Components of the database that affect the allocation of system processes, such as:
SQL*Net |
Multi-Threaded Server (MTS) |
Parallel Query |
Parallel Server |
The layout and sizes of physical storage
The sizing of database objects, such as:
Tables |
Indexes |
Rollback segments |
Sort areas |
Temporary tablespaces |
Redo logs |
Partition tables |
Index-only tables |
The amount and allocation of memory, such as:
Database buffers |
Redo log buffers |
Shared pool |