| Parameter Name |
Use |
| audit_trail |
Enables or disables writing records to the audit trail. Note that this merely enables auditing; audit actions must be configured separately. |
| background_dump_dest |
Destination directory for Oracle background process trace files, including alert.log |
| compatible |
Compatibility level of the database. Prevents the use of database features introduced at versions higher than the value of this parameter |
| control_files |
Control files for this database |
| db_block_buffers |
Number of database blocks contained in the buffer cache. Buffer cache = db_block_buffers * db_block_size |
| db_block_size |
Size of the database block. This cannot be changed after the database is created. |
| db_files |
Maximum number of database files that can be opened |
| db_name |
Name of the database. If used, it must match the database name used in the CREATE DATABASE statement |
| db_file_multiblock_read_count |
Maximum number of database blocks read in one I/O. Used for sequential scans |
| dml_locks |
Max number of DML locks for all tables for all users |
| log_archive_dest |
Destination of archived redo log files |
| log_archive_start |
Enables or disables automatic archiving. If TRUE, the ARCH process automatically starts when the instance is started |
| log_buffer |
Number of bytes allocated to the redo log buffer |
| log_checkpoint_interval |
Number of redo log file blocks that must be filled to trigger a checkpoint |
| max_dump_file_size |
Max size in operating system blocks of Oracle trace files |
| processes |
Max number of OS processes that can connect to the database, including the background processes. Important for tuning shared memory |
| remote_login_passwordfile |
Specifies whether a password file is used for remote internal authentication and how many databases can use a single password file. It can be set to NONE, SHARED, and EXCLUSIVE |
| rollback_segments |
List of rollback segments to automatically take online at database startup |
| sequence_cache_entries |
Number of sequences that can be cached in the SGA. This should be sest to the maximum number of sequences that will be used in the instance at any time |
| shared_pool_size |
Size of the shared pool, in bytes |
| snapshot_refresh_processes |
Number of SNP processes to start at instance startup. SNP processes are responsible for refreshing snapshots and running database jobs submitted with DBMS_JOB |
| timed_statistics |
Enables or disables the collecting of timing statistics for the database. Some performance hits if set to true. |
| user_dump_dest |
Destination directory for user trace files, including those generated by setting sql_trace to true |