In addition, the data files should be distributed among as many disk drives as feasible. Finally, the Oracle8 i binary files, support files, and data files should be placed according to the Oracle Optimal Flexible Architecture model. It is often useful, however, to use a dedicated network connection for archive log generation and database backups. Since the time available to back up the database is often limited, a high-performance LAN segment dedicated to backup and recovery can greatly improve performance. The Oracle8 i database-block buffers, shared pool, and server processes are the largest consumers of system memory.
Internal jobs use shared pool memory and the redo log uses the log buffer.
The size of the memory allocated to the SGA significantly affects system performance. The number of database-block buffers and the size of the database block determines the amount of memory used for the database buffer cache. The library cache, data dictionary, log buffer, and a few other internal structures use the shared pool. In addition, the shared pool of memory is used for parallel query message passing. Depending on the level of parallelism, shared pool size may be critical.