| Name | Value | Description |
|---|---|---|
| background_dump_des | bdump | Detached process dump directory |
| checkpoint_process | TRUE | Create a separate checkpoint process |
| control_files | control file names list | |
| core_dump_dest | core dump destination | |
| cput_count | 6 | Number of cpus for the instance |
| db_block_buffers | 144000 | number of database blocks cached in memory |
| db_block_size | 8192 | Size of the database block size |
| db_domain | WORLD | global database name |
| db_file_multiblock_read_count | 16 | Database block to be read each I/O |
| db_file_simultaneous_writes | 4 | Maximum simultaneous writes per database file |
| db_files | 1022 | Maximum allowable number of database files |
| db_name | you provide the name | Database Name |
| db_writers | 1 | The number of database writers |
| global_names | FALSE | Enforce that database links have same name as remote database |
| log_archive_buffer_size | 32 | size of each buffer in log file blocks |
| log_archiving_buffers | 5 | Number of buffers allocate for archiving |
| log_archive_dest | Archival destination | |
| log_archive_duplex_dest | duplex the archive files | |
| log_archive_format | %t_s.arch | file format of the archive files |
| log_archive_start | TRUE | Start archival process on SGA |
| log_buffer | 3145728 | Redo circular buffer size |
| log_checkpoint_interval | 31457280 | Indicates the number of redo blocks for checkpoint threshold |
| log_checkout_timeout | 0 | Maximum time interval in seconds between checkpoints |
| log_files | 255 | Maximum allowable number of log files |
| max_dump_file_size | maximum size of the trace file | |
| open_cursors | 50 | maximum number of cursors per process |
| optimizer mode | CHOOSE | Optimizer Mode |
| oracle_trace_enable | FALSE | Oracle TRACE |
| os_roles | FALSE | Retrieves roles from the operating system |
| processes | 100 | Maximum number of user processes |
| remote_login_passwordfile | NONE | Password file usage |
| rollback_segments | rbs01,rbs02 | Undo segment list |
| sequence_cache_entries | 12 | Number of sequence cache entries |
| shared_pool_reserved_size | 0 | Size in bytes of reserved area of shared pool |
| shared_pool_size | 262144000 | Size in Bytes of shared pool |
| sort_area_retained_size | 5422880 | Size of in-memory sort work area |
| sort_area_size | 20971520 | Size of in-memory sort area |
| sort_write_buffer_size | 65536 | Szie of each sort direct write buffers |
| sort_write_buffers | 4 | Number of sort direct write buffers |
| sql_trace | FALSE | Enable SQL Trace |
| timed_statistics | TRUE | Maintain internal timing statistics |
| transactions | 126 | number of concurrent active transactions |
| user_dump_dest | user process dump directory |
