| NAME | VALUE | DISPLAY_VALUE | DESCRIPTION |
| processes | 300 | 300 | user processes |
| sessions | 480 | 480 | user and system sessions |
| timed_statistics | TRUE | TRUE | maintain internal timing statistics |
| timed_os_statistics | 0 | 0 | internal os statistic gathering interval in seconds |
| resource_limit | TRUE | TRUE | master switch for resource limit |
| license_max_sessions | 200 | 200 | maximum number of non-system user sessions allowed |
| license_sessions_warning | 0 | 0 | warning level for number of non-system user sessions |
| cpu_count | 12 | 12 | number of CPUs for this instance |
| event | 10336 trace name context forever | 10336 trace name context forever | debug event control - default null string |
| sga_max_size | 1577058304 | 1504M | max total SGA size |
| use_large_pages | TRUE | TRUE | Use large pages if available (TRUE/FALSE/ONLY) |
| pre_page_sga | TRUE | TRUE | pre-page sga for process |
| shared_memory_address | 0 | 0 | SGA starting address (low order 32-bits on 64-bit platforms) |
| hi_shared_memory_address | 0 | 0 | SGA starting address (high order 32-bits on 64-bit platforms) |
| use_indirect_data_buffers | FALSE | FALSE | Enable indirect data buffers (very large SGA on 32-bit platforms) |
| lock_sga | FALSE | FALSE | Lock entire SGA in physical memory |
| shared_pool_size | 0 | 0 | size in bytes of shared pool |
| large_pool_size | 268435456 | 256M | size in bytes of large pool |
| java_pool_size | 0 | 0 | size in bytes of java pool |
| streams_pool_size | 67108864 | 64M | size in bytes of the streams pool |
| shared_pool_reserved_size | 40265318 | 40265318 | size in bytes of reserved area of shared pool |
| _shared_pool_reserved_pct | 10 | 10 | percentage memory of the shared pool allocated for the reserved area |
| java_soft_sessionspace_limit | 0 | 0 | warning limit on size in bytes of a Java sessionspace |
| java_max_sessionspace_size | 0 | 0 | max allowed size in bytes of a Java sessionspace |
| pga_aggregate_limit | 2147483648 | 2G | limit of aggregate PGA memory consumed by the instance |
| spfile | /global/tdcolmy/bkup/tdcolmy/dba/spfiletdcolmy.ora | /global/tdcolmy/bkup/tdcolmy/dba/spfiletdcolmy.ora | server parameter file |
| instance_type | RDBMS | RDBMS | type of instance to be executed |
| nls_language | ENGLISH | ENGLISH | NLS language name |
| nls_territory | AUSTRALIA | AUSTRALIA | NLS territory name |
| nls_date_language | ENGLISH | ENGLISH | NLS date language name |
| nls_comp | BINARY | BINARY | NLS comparison |
| nls_length_semantics | BYTE | BYTE | create columns using byte or char semantics by default |
| nls_nchar_conv_excp | FALSE | FALSE | NLS raise an exception instead of allowing implicit conversion |
| filesystemio_options | setall | setall | IO operations on filesystem files |
| dnfs_batch_size | 4096 | 4096 | Max number of dNFS asynch I/O requests queued per session |
| clonedb | FALSE | FALSE | clone database |
| instant_restore | FALSE | FALSE | instant repopulation of datafiles |
| disk_asynch_io | TRUE | TRUE | Use asynch I/O for random access devices |
| tape_asynch_io | TRUE | TRUE | Use asynch I/O requests for tape devices |
| dbwr_io_slaves | 0 | 0 | DBWR I/O slaves |
| backup_tape_io_slaves | FALSE | FALSE | BACKUP Tape I/O slaves |
| resource_manager_cpu_allocation | 12 | 12 | Resource Manager CPU allocation |
| encrypt_new_tablespaces | CLOUD_ONLY | CLOUD_ONLY | whether to encrypt newly created tablespaces |
| allow_group_access_to_sga | FALSE | FALSE | Allow read access for SGA to users of Oracle owner group |
| optimizer_adaptive_plans | TRUE | TRUE | controls all types of adaptive plans |
| optimizer_adaptive_statistics | FALSE | FALSE | controls all types of adaptive statistics |
| file_mapping | FALSE | FALSE | enable file mapping |
| threaded_execution | FALSE | FALSE | Threaded Execution Mode |
| gcs_server_processes | 0 | 0 | number of background gcs server processes to start |
| sga_target | 1577058304 | 1504M | Target size of SGA |
| memory_target | 0 | 0 | Target size of Oracle SGA and PGA memory |
| memory_max_target | 0 | 0 | Max size for Memory Target |
| control_files | /global/tdcolmy/bkup/tdcolmy/dba/tdcolmy_ctl1.con, /global/tdcolmy/db/tdcolmy/dbs/tdcolmy_ctl2.con, /global/tdcolmy/bkup/tdcolmy/ora_redo/tdcolmy_ctl3.con | /global/tdcolmy/bkup/tdcolmy/dba/tdcolmy_ctl1.con, /global/tdcolmy/db/tdcolmy/dbs/tdcolmy_ctl2.con, /global/tdcolmy/bkup/tdcolmy/ora_redo/tdcolmy_ctl3.con | control file names list |
| control_file_record_keep_time | 37 | 37 | control file record keep time in days |
| db_block_buffers | 0 | 0 | Number of database blocks cached in memory |
| db_block_checksum | TYPICAL | TYPICAL | store checksum in db blocks and check during reads |
| db_ultra_safe | OFF | OFF | Sets defaults for other parameters that control protection levels |
| db_block_size | 8192 | 8192 | Size of database block in bytes |
| db_cache_size | 0 | 0 | Size of DEFAULT buffer pool for standard block size buffers |
| db_2k_cache_size | 0 | 0 | Size of cache for 2K buffers |
| db_4k_cache_size | 0 | 0 | Size of cache for 4K buffers |
| db_8k_cache_size | 0 | 0 | Size of cache for 8K buffers |
| db_16k_cache_size | 0 | 0 | Size of cache for 16K buffers |
| db_32k_cache_size | 0 | 0 | Size of cache for 32K buffers |
| db_keep_cache_size | 0 | 0 | Size of KEEP buffer pool for standard block size buffers |
| db_recycle_cache_size | 0 | 0 | Size of RECYCLE buffer pool for standard block size buffers |
| db_big_table_cache_percent_target | 0 | 0 | Big table cache target size in percentage |
| db_writer_processes | 1 | 1 | number of background database writer processes to start |
| db_flash_cache_size | 0 | 0 | flash cache size for db_flash_cache_file |
| db_cache_advice | ON | ON | Buffer cache sizing advisory |
| compatible | 12.1.0 | 12.1.0 | Database will be completely compatible with this software version |
| log_archive_start | FALSE | FALSE | start archival process on SGA initialization |
| log_archive_min_succeed_dest | 1 | 1 | minimum number of archive destinations that must succeed |
| standby_archive_dest | ?/dbs/arch | ?/dbs/arch | standby database archivelog destination text string |
| log_archive_trace | 0 | 0 | Establish archivelog operation tracing level |
| log_archive_format | _%r_%t_%S.arc | _%r_%t_%S.arc | archival destination format |
| log_archive_max_processes | 4 | 4 | maximum number of active ARCH processes |
| log_buffer | 13328384 | 13016K | redo circular buffer size |
| log_checkpoint_interval | 0 | 0 | # redo blocks checkpoint threshold |
| log_checkpoint_timeout | 1800 | 1800 | Maximum time interval between checkpoints in seconds |
| archive_lag_target | 0 | 0 | Maximum number of seconds of redos the standby could lose |
| db_files | 500 | 500 | max allowable # db files |
| db_file_multiblock_read_count | 128 | 128 | db block to be read each IO |
| read_only_open_delayed | FALSE | FALSE | if TRUE delay opening of read only files until first access |
| cluster_database | FALSE | FALSE | if TRUE startup in cluster database mode |
| parallel_server | FALSE | FALSE | if TRUE startup in parallel server mode |
| parallel_server_instances | 1 | 1 | number of instances to use for sizing OPS SGA structures |
| cluster_database_instances | 1 | 1 | number of instances to use for sizing cluster db SGA structures |
| db_recovery_file_dest_size | 0 | 0 | database recovery files size limit |
| standby_file_management | MANUAL | MANUAL | if auto then files are created/dropped automatically on standby |
| db_unrecoverable_scn_tracking | TRUE | TRUE | Track nologging SCN in controlfile |
| thread | 0 | 0 | Redo thread to mount |
| fast_start_io_target | 0 | 0 | Upper bound on recovery reads |
| fast_start_mttr_target | 0 | 0 | MTTR target in seconds |
| log_checkpoints_to_alert | FALSE | FALSE | log checkpoint begin/end to alert file |
| db_lost_write_protect | NONE | NONE | enable lost write detection |
| recovery_parallelism | 0 | 0 | number of server processes to use for parallel recovery |
| enable_goldengate_replication | FALSE | FALSE | goldengate replication enabled |
| db_flashback_retention_target | 1440 | 1440 | Maximum Flashback Database log retention time in minutes. |
| dml_locks | 800 | 800 | dml locks - one for each table modified in a transaction |
| replication_dependency_tracking | TRUE | TRUE | tracking dependency for Replication parallel propagation |
| transactions | 528 | 528 | max. number of concurrent active transactions |
| transactions_per_rollback_segment | 5 | 5 | number of active transactions per rollback segment |
| undo_management | AUTO | AUTO | instance runs in SMU mode if TRUE, else in RBU mode |
| undo_tablespace | ORAUNDO | ORAUNDO | use/switch undo tablespace |
| temp_undo_enabled | FALSE | FALSE | is temporary undo enabled |
| undo_retention | 0 | 0 | undo retention in seconds |
| fast_start_parallel_rollback | LOW | LOW | max number of parallel recovery slaves that may be used |
| resumable_timeout | 0 | 0 | set resumable_timeout |
| instance_number | 0 | 0 | instance number |
| heat_map | OFF | OFF | ILM Heatmap Tracking |
| inmemory_size | 0 | 0 | size in bytes of in-memory area |
| db_block_checking | FALSE | FALSE | header checking and data and index block checking |
| recyclebin | ON | ON | recyclebin processing |
| db_index_compression_inheritance | NONE | NONE | options for table or tablespace level compression inheritance |
| db_securefile | PREFERRED | PREFERRED | permit securefile storage during lob creation |
| inmemory_force | DEFAULT | DEFAULT | Force tables to be in-memory or not |
| inmemory_query | ENABLE | ENABLE | Specifies whether in-memory queries are allowed |
| inmemory_max_populate_servers | 0 | 0 | maximum inmemory populate servers |
| inmemory_trickle_repopulate_servers_percent | 1 | 1 | inmemory trickle repopulate servers percent |
| serial_reuse | disable | disable | reuse the frame segments |
| ldap_directory_access | NONE | NONE | RDBMS's LDAP access option |
| ldap_directory_sysauth | no | no | OID usage parameter |
| os_roles | FALSE | FALSE | retrieve roles from the operating system |
| max_enabled_roles | 150 | 150 | max number of roles a user can have enabled |
| remote_os_authent | FALSE | FALSE | allow non-secure remote clients to use auto-logon accounts |
| remote_os_roles | FALSE | FALSE | allow non-secure remote clients to use os roles |
| sec_case_sensitive_logon | TRUE | TRUE | case sensitive password enabled for logon |
| O7_DICTIONARY_ACCESSIBILITY | FALSE | FALSE | Version 7 Dictionary Accessibility Support |
| remote_login_passwordfile | EXCLUSIVE | EXCLUSIVE | password file usage parameter |
| license_max_users | 0 | 0 | maximum number of named users that can be created in the database |
| audit_sys_operations | TRUE | TRUE | enable sys auditing |
| DBFIPS_140 | FALSE | FALSE | Enable use of crypographic libraries in FIPS mode, public |
| unified_audit_sga_queue_size | 1048576 | 1048576 | Size of Unified audit SGA Queue |
| db_domain | BMW | BMW | directory part of global database name stored with CREATE DATABASE |
| global_names | FALSE | FALSE | enforce that database links have same name as remote database |
| distributed_lock_timeout | 60 | 60 | number of seconds a distributed transaction waits for a lock |
| commit_point_strength | 1 | 1 | Bias this node has toward not preparing in a two-phase commit |
| global_txn_processes | 1 | 1 | number of background global transaction processes to start |
| shared_servers | 0 | 0 | number of shared servers to start up |
| local_listener | (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=localhost)(Port=1546))) | (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=localhost)(Port=1546))) | local listener |
| use_dedicated_broker | FALSE | FALSE | Use dedicated connection broker |
| connection_brokers | ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1)) | ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1)) | connection brokers specification |
| cursor_space_for_time | FALSE | FALSE | use more memory in order to get faster execution |
| session_cached_cursors | 200 | 200 | Number of cursors to cache in a session. |
| remote_dependencies_mode | TIMESTAMP | TIMESTAMP | remote-procedure-call dependencies mode parameter |
| plsql_v2_compatibility | FALSE | FALSE | PL/SQL version 2.x compatibility flag |
| plsql_warnings | DISABLE:ALL | DISABLE:ALL | PL/SQL compiler warnings settings |
| plsql_code_type | INTERPRETED | INTERPRETED | PL/SQL code-type |
| plsql_debug | FALSE | FALSE | PL/SQL debug |
| plsql_optimize_level | 2 | 2 | PL/SQL optimize level |
| plscope_settings | identifiers:all | identifiers:all | plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data |
| permit_92_wrap_format | TRUE | TRUE | allow 9.2 or older wrap format in PL/SQL |
| java_jit_enabled | TRUE | TRUE | Java VM JIT enabled |
| java_restrict | none | none | Restrict Java VM Access |
| job_queue_processes | 10 | 10 | maximum number of job queue slave processes |
| parallel_min_percent | 0 | 0 | minimum percent of threads required for parallel query |
| create_bitmap_area_size | 8388608 | 8388608 | size of create bitmap buffer for bitmap index |
| bitmap_merge_area_size | 1048576 | 1048576 | maximum memory allow for BITMAP MERGE |
| cursor_sharing | EXACT | EXACT | cursor sharing mode |
| result_cache_mode | MANUAL | MANUAL | result cache operator usage mode |
| parallel_min_servers | 8 | 8 | minimum parallel query servers per instance |
| parallel_max_servers | 8 | 8 | maximum parallel query servers per instance |
| parallel_execution_message_size | 16384 | 16384 | message buffer size for parallel execution |
| hash_area_size | 131072 | 131072 | size of in-memory hash work area |
| result_cache_max_size | 7897088 | 7712K | maximum amount of memory to be used by the cache |
| result_cache_max_result | 5 | 5 | maximum result size as percent of cache size |
| result_cache_remote_expiration | 0 | 0 | maximum life time (min) for any result using a remote object |
| shadow_core_dump | partial | partial | Core Size for Shadow Processes |
| background_core_dump | partial | partial | Core Size for Background Processes |
| background_dump_dest | /lfs/oracle/ora12102190716V0/rdbms/log | /lfs/oracle/ora12102190716V0/rdbms/log | Detached process dump directory |
| user_dump_dest | /lfs/oracle/ora12102190716V0/rdbms/log | /lfs/oracle/ora12102190716V0/rdbms/log | User process dump directory |
| core_dump_dest | /global/tdcolmy/bkup/tdcolmy/diag/rdbms/tdcolmy/tdcolmy/cdump | /global/tdcolmy/bkup/tdcolmy/diag/rdbms/tdcolmy/tdcolmy/cdump | Core dump directory |
| audit_file_dest | /global/tdcolmy/bkup/tdcolmy/dump/adump | /global/tdcolmy/bkup/tdcolmy/dump/adump | Directory in which auditing files are to reside |
| audit_syslog_level | LOCAL0.INFO | LOCAL0.INFO | Syslog facility and level |
| object_cache_optimal_size | 102400 | 102400 | optimal size of the user session's object cache in bytes |
| object_cache_max_size_percent | 10 | 10 | percentage of maximum size over optimal of the user session's object cache |
| session_max_open_files | 10 | 10 | maximum number of open files allowed per session |
| open_links | 10 | 10 | max # open links per session |
| open_links_per_instance | 4 | 4 | max # open links per instance |
| optimizer_features_enable | 12.1.0.2 | 12.1.0.2 | optimizer plan compatibility parameter |
| audit_trail | OS | OS | enable system auditing |
| sort_area_size | 65536 | 65536 | size of in-memory sort work area |
| sort_area_retained_size | 0 | 0 | size of in-memory sort work area retained between fetch calls |
| cell_offload_processing | TRUE | TRUE | enable SQL processing offload to cells |
| cell_offload_decryption | TRUE | TRUE | enable SQL processing offload of encrypted data to cells |
| cell_offload_compaction | ADAPTIVE | ADAPTIVE | Cell packet compaction strategy |
| cell_offload_plan_display | AUTO | AUTO | Cell offload explain plan display |
| open_cursors |
|