Home > Workload Solutions > Oracle > White Papers > Oracle Database 19c Best Practices on Dell PowerEdge Servers and PowerStore T Model Arrays > Oracle configuration
The Oracle database configuration includes many default settings that reflect a new installation of the database. In the following table, a subset of the database configuration parameters is listed to show the baseline settings (default settings):
Table 7. Database configuration parameters
Parameters | Values |
SGA_TARGET | 64 GB |
PGA_TARGET | 10 GB |
DB_BLOCK_SIZE | 8 K |
PROCESSES | 640 |
SESSIONS | 984 |
TRANSACTIONS | 1082 |
UNDO_MANAGEMENT | AUTO |
UNDO_TABLESPACE | UNDOTBS1 |
FILESYSTEM_IO_OPTIONS | NONE |
DISK_ASYNC_IO | TRUE |
DB_FILE_MULTIBLOCK_READ_COUNT | 128 |
DB_WRITER_PROCESS | 1 |
REDOLOG FILE SIZE | 200 MB (each) |
ASM ALLOCATION UNIT SIZE | 4 MB |
REDO / TEMP FILES STRIPING | COARSE |
In reviewing the configuration parameters, the overall profile can be labeled as an entry-level database. An entry-level database configuration provides a foundation to build upon best practices. Over the course of validating best practices the database configuration will change to optimize performance. This approach of starting with a minimal configuration and adding best practices has the benefit of enabling customers to address database growth challenges using these validated recommendations.