Here are some of the parameters of the Oracle profile init<SID>.ora . You should check the setting of these parameters if bottlenecks occur in your database system. Refer to the Oracle documentation for more information.

DB_BLOCK_BUFFERS (Oracle)

DB_BLOCK_SIZE (Oracle)

DB_WRITERS (Oracle)

LOG_ARCHIVE_START (Oracle)

LOG_BUFFER (Oracle)

LOG_CHECKPOINT_INTERVAL (Oracle)

ROW_CACHE_CURSORS (Oracle)

SHARED_POOL_SIZE (Oracle)

SORT_AREA_SIZE (Oracle)

TIMED_STATISTICS (Oracle)

Parameter Changes (Oracle)