|
Oracle |
Configuration & Performance of the Database |
Configuration & Performance of the DB Server |
|
The following table provides an overview of all Oracle parameters and indicates how they should be set when you use them AE.
| Parameter | Recommended value | Relevant for AE | Description | Oracle version |
|---|---|---|---|---|
| DBFIPS_140 | No | Enable use of cryptographic libraries in FIPS mode | 12 | |
| active_instance_count | Yes | For AE in the RAC (alternative backup via SERVICE in the RAC). | 10, 11 and 12 | |
| aq_tm_processes | No | 10, 11 and 12 | ||
| archive_lag_target | No | 10, 11 and 12 | ||
| asm_diskgroup | Only for an ASM instance | No | 10, 11 and 12 | |
| asm_diskstring | Only for an ASM instance | No | 10, 11 and 12 | |
| asm_power_limit | Only for an ASM instance | No | 10, 11 and 12 | |
| asm_preferred_read_failure_groups | Only for an ASM instance | No | 11 and 12 | |
| audit_file_dest | D:\ORACLE\ADMIN\O111\ADUMP | No | You can use any path. | 10, 11 and 12 |
| audit_sys_operations | FALSE | No | Depending on your security guidelines. | 10, 11 and 12 |
| audit_syslog_level | No | Depending on your security guidelines. | 11gR2 and 12 | |
| awr_snapshot_time_offset | No | AWR Snapshot offset to full hour | 12 | |
| audit_trail | DB | No | Depending on your security guidelines. | 10, 11 and 12 |
| background_core_dump | partial | No | 10, 11 and 12 | |
| background_dump_dest | D:\ORACLE\DIAG\RDBMS\O111\O111\TRACE | No | Is deprecated as of Oracle version 11; you can use any path. | 10, 11 and 12 |
| backup_tape_io_slaves | FALSE | No | Relevant for an RMAN backup. | 10, 11 and 12 |
| bitmap_merge_area_size | No | AE does not use bitmap indexes. | 10, 11 and 12 | |
| blank_trimming | FALSE | No | 10, 11 and 12 | |
| buffer_pool_keep | Yes | Is deprecated and has been replaced by db_keep_cache_size. | 10, 11 and 12 | |
| buffer_pool_recycle | Yes | Is deprecated and has been replaced by db_recycle_cache_size. | 10, 11 and 12 | |
| cell_offload% | No | Cell Offload configurationA set of constituent components that make up a system. This includes information on how the components are connected including the settings applied. for Exadata only | 12 | |
| circuits | Yes | AE does not support Shared Server operations. | 10, 11 and 12 | |
| client_result_cache_lag | Yes | AE does not yet support the feature Result Cache. | 11 and 12 | |
| client_result_cache_size | Yes | AE does not yet support the feature Result Cache. | 11 and 12 | |
| clonedb | No | |||
| cluster_databaseA database is an organized collection of data including relevant data structures. | Yes | TRUE for AE in the RAC, FALSE for Single Instance Database. | 10, 11 and 12 | |
| cluster_database_instances | Yes | The number of RAC instances. | 10, 11 and 12 | |
| cluster_interconnects | No | RAC interconnect selection. | 10, 11 and 12 | |
| commit_logging | Do not set or IMMEDIATE | Yes | Currently, AE does not support the feature COMMIT BATCH for the Automation Engine. | 11 and 12 |
| commit_point_strength | No | 10, 11 and 12 | ||
| commit_wait | Do not set or WAIT | Yes | AE does not yet support the feature COMMIT NOWAIT for the Automation Engine. | 11 and 12 |
| commit_write | Yes | Is deprecated. | 10 and 11 | |
| common_user_prefix | C## | No | Used for Multitenant Database | 12 |
| compatible | 12.1.0.2.0 | Yes | This should contain the current Oracle version. | 10, 11 and 12 |
| control_file_record_keep_time | 7 | No | 10, 11 and 12 | |
| control_files | No | 10, 11 and 12 | ||
| control_management_pack_access | DIAGNOSTIC+TUNING | No | Depending on your Oracle Management Pack Licenses. | 11 and 12 |
| core_dump_dest | D:\ORACLE\DIAG\RDBMS\O111\O111\CDUMP | No | You can use any path. | 10, 11 and 12 |
| cpu_count | No | It is automatically set to the number of CPUs. | 10, 11 and 12 | |
| create_bitmap_area_size | No | AE does not use bitmap indexes. | 10, 11 and 12 | |
| create_stored_outlines | No | AE does not use Stored Outlines. | 10, 11 and 12 | |
| cursor_sharing | EXACT | Yes | As of Oracle version 11, you can implement FORCE at your own risk. | 10, 11 and 12 |
| cursor_space_for_time | FALSE | No | You can use it for performance tuning measures. | 10, 11 and 12 |
| db_big_table_cache_percent_target | Yes | Do not set, influence query performance for data warehouse workloads | 12 | |
| db_block_buffers | Yes | AE does not recommend using this parameter because it has been replaced by the parameter db_cache_size. | 10, 11 and 12 | |
| db_block_checking | FALSE | No | 10, 11 and 12 | |
| db_block_checksum | TYPICAL | No | 10, 11 and 12 | |
| db_block_size | 8192 | Yes | Automic recommends a standard block size of 8K; the allowed minimum is 4K. | 10, 11 and 12 |
| db_cache_advice | ON | Yes | 10, 11 and 12 | |
| db_cache_size | Yes | The required buffer cache size depends on your database size. | 10, 11 and 12 | |
| db_create_file_dest | No | 10, 11 and 12 | ||
| db_create_online_log_dest_1 | No | 10, 11 and 12 | ||
| db_create_online_log_dest_2 | No | 10, 11 and 12 | ||
| db_create_online_log_dest_3 | No | 10, 11 and 12 | ||
| db_create_online_log_dest_4 | No | 10, 11 and 12 | ||
| db_create_online_log_dest_5 | No | 10, 11 and 12 | ||
| db_domain | No | 10, 11 and 12 | ||
| db_file_multiblock_read_count | 32 | Yes | The database administrator can change it for tuning measures. | 10, 11 and 12 |
| db_file_name_convert | No | 10, 11 and 12 | ||
| db_files | No | 10, 11 and 12 | ||
| db_flash_cache_file | Yes | Used for Smart Flash Cache within Oracle Buffer Cache, currently not supported by AE may be used at own risk | 11gR2 and 12 | |
| db_flash_cache_size | Yes | Used for Smart Flash Cache within Oracle Buffer Cache, currently not supported by AE may be used at own risk | 11gR2 and 12 | |
| db_flashback_retention_target | No | 10, 11 and 12 | ||
| db_keep_cache_size | Yes | Automic Supports the use of KEEP CACHE and RECYCLE CACHE as tuning measures. | 10, 11 and 12 | |
| db_lost_write_protect | No | 10, 11 and 12 | ||
| db_name | No | 10, 11 and 12 | ||
| db_performance_profile | No | 12 | ||
| db_recovery_file_dest | No | 10, 11 and 12 | ||
| db_recovery_file_dest_size | No | 10, 11 and 12 | ||
| db_recycle_cache_size | Yes | Automic Supports the use of KEEP CACHE and RECYCLE CACHE as tuning measures. | 10, 11 and 12 | |
| db_securefile | PERMITTED | Yes | The database administrator can change it as a tuning purposes. | 11 and 12 |
| db_ultra_safe | OFF | No |
Note that you should only change this value (other than OFF) for troubleshooting purposes because doing so can affect the performance of your system negatively. |
11 and 12 |
| db_unique_name | No | 10, 11 and 12 | ||
| db_unrecoverable_scn_tracking | No | 12 | ||
| dbwr_io_slaves | Yes | For tuning the DBWR process, you can either use dbwr_io_slaves or db_writer_processes. | 10, 11 and 12 | |
| db_writer_processes | Yes | For tuning the DBWR process, you can either use dbwr_io_slaves or db_writer_processes. | 10, 11 and 12 | |
| defferred_segment_creation | TRUE | No | 11gR2 and 12 | |
| db_16k_cache_size | Yes | AE accepts the use of different DB block sizes as a tuning measure but it does not explicitly support it in version upgrades. | 10, 11 and 12 | |
| db_2k_cache_size | Yes | AE accepts the use of different DB block sizes as a tuning measure but it does not explicitly support it in version upgrades. | 10, 11 and 12 | |
| db_32k_cache_size | Yes | AE accepts the use of different DB block sizes as a tuning measure but it does not explicitly support it in version upgrades. | 10, 11 and 12 | |
| db_4k_cache_size | Yes | AE accepts the use of different DB block sizes as a tuning measure but it does not explicitly support it in version upgrades. | 10, 11 and 12 | |
| db_8k_cache_size | Yes | AE accepts the use of different DB block sizes as a tuning measure but it does not explicitly support it in version upgrades. | 10, 11 and 12 | |
| ddl_lock_timeout | No | 11 and 12 | ||
| ddl_wait_for_locks | FALSE | No | 10 | |
| dg_broker_config_file1 | No | 10, 11 and 12 | ||
| dg_broker_config_file2 | No | 10, 11 and 12 | ||
| dg_broker_start | FALSE | No | 10, 11 and 12 | |
| diagnostic_dest | D:\ORACLE | No | You can use any path. | 11 and 12 |
| disk_asynch_io | TRUE | Yes | Automic recommends using TRUE unless there are known OS producer limitations. | 10, 11 and 12 |
| dispatchers | No | 10, 11 and 12 | ||
| distributed_lock_timeout | No | 10, 11 and 12 | ||
| dml_locks | >= 500 | Yes | You can increase this value in large AE installationations. | 10, 11 and 12 |
| dnfs_batch_size | Yes | Max number of dNFS async I/O requests queued per session | 11gR2 and 12 | |
| drs_start | No | This parameter is deprecated. | 10, 11 and 12 | |
| dst_upgrade_insert_conv | No | 12 | ||
| enable_ddl_logging | No | 11 and 12 | ||
| enable_goldengate_replication | No | 12 | ||
| enable_pluggable_database | No | 12 | ||
| exclude_seed_cdb_view | No | Related to Multitenant Option | 12 | |
| event | Yes | This parameter is used for troubleshooting purposes. | 10, 11 and 12 | |
| fal_client | No | 10, 11 and 12 | ||
| fal_server | No | 10, 11 and 12 | ||
| fast_start_io_target | No | This parameter is deprecated. | 10, 11 and 12 | |
| fast_start_mttr_target | No | 10, 11 and 12 | ||
| fast_start_parallel_rollback | No | 10, 11 and 12 | ||
| fileio_network_adapters | No | 10, 11 and 12 | ||
| file_mapping | No | 10, 11 and 12 | ||
| filesystemio_options | SETALL | Yes | Automic recommends using SETALL unless there are known OS producer limitations. | 10, 11 and 12 |
| fixed_date | NONE | Yes | This parameter must be set to NONE. | 10, 11 and 12 |
| gc_files_to_locks | Yes | This parameter must not be set for AE in the RAC. | 10, 11 and 12 | |
| gcs_server_processes | Yes | This parameter must not be set for AE in the RAC. | 10, 11 and 12 | |
| global_context_pool_size | No | This parameter is deprecated. | 10, 11 and 12 | |
| global_names | No | 10, 11 and 12 | ||
| global_txn_processes | No | 11 and 12 | ||
| hash_area_size | Yes | Automic recommends using pga_aggregate_target. | 10, 11 and 12 | |
| hi_shared_memory_address | No | 10, 11 and 12 | ||
| hs_autoregister | No | 10, 11 and 12 | ||
| ifile | No | 10, 11 and 12 | ||
| instance_groups | No | This parameter is deprecated. | 10, 11 and 12 | |
| instance_name | No | 10, 11 and 12 | ||
| instance_number | No | 10, 11 and 12 | ||
| instance_type | RDBMS | Yes | This parameter must be set to RDBMS. | 10, 11 and 12 |
| java_jit_enabled | TRUE | No | AE does not use JAVA in the database. | 11 and 12 |
| java_max_sessionspace_size | No | AE does not use JAVA in the database. | 10, 11 and 12 | |
| java_pool_size | No | AE does not use JAVA in the database. | 10, 11 and 12 | |
| java_soft_sessionspace_limit | No | AE does not use JAVA in the database. | 10, 11 and 12 | |
| job_queue_processes | No | AE does not use DBMS_JOBS. | 10, 11 and 12 | |
| large_pool_size | No | 10, 11 and 12 | ||
| ldap_directory_access | NONE | No | 10, 11 and 12 | |
| ldap_directory_sysauth | No | No | 11 and 12 | |
| license_max_sessions | No | 10, 11 and 12 | ||
| license_max_users | No | 10, 11 and 12 | ||
| license_sessions_warning | No | 10, 11 and 12 | ||
| listener_networks | No | 12 | ||
| local_listener | Yes | Make sure that this parameter is correctly configured for AE in order to register the database to the listener. | 10 and 11 | |
| lock_name_space | No | This parameter is deprecated. | 10, 11 and 12 | |
| lock_sga | FALSE | No | 10, 11 and 12 | |
| log_archive_config | No | 10, 11 and 12 | ||
| log_archive_dest | No | 10, 11 and 12 | ||
| log_archive_dest_state_% | enable | No | 10, 11 and 12 | |
| log_archive_dest_% | No | 10, 11 and 12 | ||
| log_archive_duplex_dest | No | 10, 11 and 12 | ||
| log_archive_format | ARC%S_%R.%T | No | 10, 11 and 12 | |
| log_archive_local_first | TRUE | No | This parameter is deprecated. | 10, 11 and 12 |
| log_archive_max_processes | No | 10, 11 and 12 | ||
| log_archive_min_succeed_dest | 1 | No | 10, 11 and 12 | |
| log_archive_start | No | This parameter is deprecated. | 10, 11 and 12 | |
| log_archive_trace | No | 10, 11 and 12 | ||
| log_buffer | 5653504 | Yes | Automic recommends using a log buffer of at least 5 MB and not more than 20 MB. | 10, 11 and 12 |
| log_checkpoint_interval | No | 10, 11 and 12 | ||
| log_checkpoints_to_alert | No | 10, 11 and 12 | ||
| log_checkpoint_timeout | No | 10, 11 and 12 | ||
| log_file_name_convert | No | 10, 11 and 12 | ||
| logmnr_max_persistent_sessions | No | This parameter is deprecated. | 10 | |
| max_commit_propagation_delay | 0 | Yes | As of Oracle version 11g2, this parameter is deprecated and cannot be used anymore. | 10, 11 |
| max_dispatchers | No | 10, 11 and 12 | ||
| max_dump_file_size | unlimited | No | 10, 11 and 12 | |
| max_enabled_roles | Yes | This parameter is deprecated and should not be set. | 10, 11 and 12 | |
| max_shared_servers | No | 10, 11 and 12 | ||
| max_string_size | STANDARD | Yes | Do not change! | 12 |
| memory_max_target | 2/3 of the Server memory | Yes | New Memory Management (SGA+PGA). The required size depends on the database size. AE recommends using at least 1.5 GB. | 11 and 12 |
| memory_target | 2/3 of the Server memory | Yes | New Memory Management (SGA+PGA). The required size depends on the database size. Automic recommends using at least 1.5 GB. | 11 and 12 |
| nls_calendar | No | 10, 11 and 12 | ||
| nls_comp | BINARY | Yes | For performance reasons, you should only use BINARY. | 10, 11 and 12 |
| nls_currency | No | 10, 11 and 12 | ||
| nls_date_format | No | 10, 11 and 12 | ||
| nls_date_language | No | 10, 11 and 12 | ||
| nls_dual_currency | No | 10, 11 and 12 | ||
| nls_iso_currency | No | 10, 11 and 12 | ||
| nls_language | No | 10, 11 and 12 | ||
| nls_length_semantics | CHAR | Yes | CHAR must be set in order to support UNICODE databases. | 10, 11 and 12 |
| nls_nchar_conv_excp | No | 10, 11 and 12 | ||
| nls_numeric_characters | No | 10, 11 and 12 | ||
| nls_sort | Yes | For performance reasons, Automic recommends using the default value BINARY. | 10, 11 and 12 | |
| nls_territory | No | 10, 11 and 12 | ||
| nls_time_format | No | 10, 11 and 12 | ||
| nls_timestamp_format | No | 10, 11 and 12 | ||
| nls_timestamp_tz_format | No | 10, 11 and 12 | ||
| nls_time_tz_format | No | 10, 11 and 12 | ||
| nocdb_compatible | FALSE | No | Multitenand Option | 12 |
| object_cache_max_size_percent | No | 10, 11 and 12 | ||
| object_cache_optimal_size | No | 10, 11 and 12 | ||
| olap_page_pool_size | No | 10, 11 and 12 | ||
| open_cursors | 500 | Yes | AE requires at least 500. | 10, 11 and 12 |
| open_links | No | 10, 11 and 12 | ||
| open_links_per_instance | No | 10, 11 and 12 | ||
| optimizer_adaptive_featured | TRUE | Yes | This parameter can be used for performance tuning purposes | 12 |
| optimizer_adaptive_reporting_only | FALSE | Yes | This parameter can be used for performance tuning purposes | 12 |
| optimizer_capture_sql_plan_baselines | FALSE | Yes | This parameter can be used for performance tuning purposes | 11 and 12 |
| optimizer_dynamic_sampling | 2 | Yes | AE requires a value of >= 2. Automic recommends using 2. | 10, 11 and 12 |
| optimizer_features_enable | 11.1.0.6 | Yes | Automic recommends using the current Oracle version unless you want to deactivate current optimizer features intentionally. | 10, 11 and 12 |
| optimizer_index_caching | Yes | You can use this parameter for performance tuning purposes. | 10, 11 and 12 | |
| optimizer_index_cost_adj | Yes | You can use this parameter for performance tuning purposes. | 10, 11 and 12 | |
| optimizer_inmemory_aware | Yes | You can use this parameter for performance tuning purposes - In-Memory Database Cache Option | 12 | |
| optimizer_mode | ALL_ROWS | Yes | AE requires ALL_ROWS. You can change this value for performance tuning purposes. | 10, 11 and 12 |
| optimizer_secure_view_merging | No | 10, 11 and 12 | ||
| optimizer_use_invisible_indexes | No | 11 and 12 | ||
| optimizer_use_pending_statistics | No | 11 and 12 | ||
| optimizer_use_sql_plan_baselines | Yes | You can use this parameter for performance tuning purposes. | 11 and 12 | |
| os_authent_prefix | No | 10, 11 and 12 | ||
| os_roles | No | 10, 11 and 12 | ||
| o7_dictionary_accessibility | FALSE | No | 10, 11 and 12 | |
| parallel_adaptive_multi_user | No | 10, 11 and 12 | ||
| parallel_automatic_tuning | No | This parameter is deprecated. | 10, 11 and 12 | |
| parallel_degree% Parameter | No | Do not adjust | 12 | |
| parallel_execution_message_size | No | 10, 11 and 12 | ||
| parallel_force_local | TRUE | No | If parallel query is used for some reasons it should stay on local RAC node | 12 |
| parallel_instance_group | No | 10, 11 and 12 | ||
| parallel_io_cap_enabled | Yes | You can use this parameter as a tuning measure in combination with I/O calibration. | 11 and 12 | |
| parallel_max_servers | No | 10, 11 and 12 | ||
| parallel_min_percent | No | 10, 11 and 12 | ||
| parallel_min_servers | No | 10, 11 and 12 | ||
| parallel_server | No | This parameter is deprecated. | 10, 11 and 12 | |
| parallel_server_instances | No | This parameter is deprecated. | 10, 11 and 12 | |
| parallel_server_target | No | 12 | ||
| parallel_threads_per_cpu | No | 10, 11 and 12 | ||
| pdb_file_name_convert | No | Multitenant Option | 12 | |
| pdb_lockdown | No | 12 | ||
| pdb_os_credential | No | 12 | ||
| permit_92_wrap_format | No | 12 | ||
| pga_aggregate_limit | Some 100 MB | Yes | Automic recommends a limit of 4*pga_aggregate_limit and a minimum of 2GB | 12 |
| pga_aggregate_target | Some 100 MB | Yes | Automic recommends using pga_aggregate_target (or memory_target as of Oracle version 11). You can change this value for performance tuning purposes. Automic recommends using >= 500MB. | 10, 11 and 12 |
| plscope_settings | No | 11 and 12 | ||
| plsql_ccflags | No | 10, 11 and 12 | ||
| plsql_code_type | No | 10, 11 and 12 | ||
| plsql_compiler_flags | No | This parameter is deprecated. | 10 | |
| plsql_debug | No | This parameter is deprecated. | 10, 11 and 12 | |
| plsql_native_library_dir | No | 10, 11 and 12 | ||
| plsql_native_library_subdir_count | No | 10, 11 and 12 | ||
| plsql_optimize_level | No | 10, 11 and 12 | ||
| plsql_v2_compatibility | No | This parameter is deprecated. | 10, 11 and 12 | |
| plsql_warnings | No | 10, 11 and 12 | ||
| pre_page_sga | No | 10, 11 and 12 | ||
| processes | Yes | AE requires at least 150. | 10, 11 and 12 | |
| processes_group_name | No | 12 | ||
| query_rewrite_enabled | No | 10, 11 and 12 | ||
| query_rewrite_integrity | No | 10, 11 and 12 | ||
| rdbms_server_dn | No | 10, 11 and 12 | ||
| read_only_open_delayed | No | 10, 11 and 12 | ||
| recovery_parallelism | No | 10, 11 and 12 | ||
| recyclebin | on | No | 10, 11 and 12 | |
| redo_transport_user | No | 11 and 12 | ||
| remote_archive_enable | No | This parameter is deprecated. | 10 | |
| remote_dependencies_mode | No | 10, 11 and 12 | ||
| remote_listener | Yes | A reasonable configuration for AE in the RAC is required in order to ensure that the instance can communicate with the Remote Listeners. | 10, 11 and 12 | |
| remote_login_passwordfile | No | 10, 11 and 12 | ||
| remote_os_authent | No | This parameter is deprecated. | 10, 11 and 12 | |
| remote_os_roles | No | 10, 11 and 12 | ||
| replication_dependency_tracking | No | 10, 11 and 12 | ||
| resource_limit | FALSE | Yes | No resource limits must be set for AE. | 10, 11 and 12 |
| resource_manager_cpu_allocation | Yes | You can use resource management without resource limits for AE. | 11 and 12 | |
| resource_manager_plan | Yes | You can use resource management without resource limits for AE. | 10, 11 and 12 | |
| result_cache_max_result | Yes | AE does not yet support the new feature Result Cache. | 11 and 12 | |
| result_cache_max_size | Yes | AE does not yet support the new feature Result Cache. | 11 and 12 | |
| result_cache_mode | Yes | AE does not yet support the new feature Result Cache. | 11 and 12 | |
| result_cache_remote_expiration | Yes | AE does not yet support the new feature Result Cache. | 11 and 12 | |
| resumable_timeout | No | 10, 11 and 12 | ||
| rollback_segments | No | Automic recommends using UNDO management | 10, 11 and 12 | |
| sec_case_sensitive_logon | No | Parameter is deprecated with 12c | 11 | |
| sec_max_failed_login_attempts | No | 11 and 12 | ||
| sec_protocol_error_further_action | No | 11 and 12 | ||
| sec_protocol_error_trace_action | No | 11 and 12 | ||
| sec_return_server_release_banner | No | 11 and 12 | ||
| serial_reuse | disable | No | This parameter is deprecated. | 10, 11 and 12 |
| service_names | No | 10, 11 and 12 | ||
| session_cached_cursors | No | 10, 11 and 12 | ||
| session_max_open_files | No | 10, 11 and 12 | ||
| sessions | Yes | The default value depends on the parameter processes. | 10, 11 and 12 | |
| sga_max_size | Max. 2/3 of the Server memory | Yes | You can use this parameter for performance tuning purposes. | 10, 11 and 12 |
| sga_target | Max. 2/3 of the Server memory | Yes | You can use this parameter for performance tuning purposes. | 10, 11 and 12 |
| shadow_core_dump | No | 10, 11 and 12 | ||
| shared_memory_address | No | 10, 11 and 12 | ||
| shared_pool_reserved_size | Yes | Automic recommends using the parameter sga_target or memory_target. | 10, 11 and 12 | |
| shared_pool_size | Yes | Automic recommends using the parameter sga_target or memory_target. | 10, 11 and 12 | |
| shared_servers | No | 10, 11 and 12 | ||
| shared_server_sessions | No | 10, 11 and 12 | ||
| skip_unusable_indexes | TRUE | Yes | This value must be set to TRUE. | 10, 11 and 12 |
| smtp_out_server | No | 10, 11 and 12 | ||
| sort_area_retained_size | Yes | Automic recommends using the parameter pga_aggregate_target or memory_target as of Oracle version 11. | 10, 11 and 12 | |
| sort_area_size | Yes | Automic recommends using the parameter pga_aggregate_target or memory_target as of Oracle version 11. | 10, 11 and 12 | |
| spatial_vector_acceleration | No | 12 | ||
| spfile | No | Automic recommends using SPFILEs. | 10, 11 and 12 | |
| sql_trace | No | This parameter is deprecated. | 10, 11 and 12 | |
| sqltune_category | No | 10, 11 and 12 | ||
| sql_version | No | This parameter is deprecated. | 10, 11 and 12 | |
| sql92_security | No | 10, 11 and 12 | ||
| standby_archive_dest | No | This parameter is deprecated. | 10, 11 and 12 | |
| standby_file_management | No | 10, 11 and 12 | ||
| star_transformation_enabled | FALSE | Yes | You can use this parameter for performance tuning purposes. | 10, 11 and 12 |
| statistics_level | TYPICAL | Yes | You can use this parameter for performance tuning purposes. Automic recommends using TYPICAL or ALL. | 10, 11 and 12 |
| streams_pool_size | No | 10, 11 and 12 | ||
| tape_asynch_io | No | 10, 11 and 12 | ||
| thread | No | 10, 11 and 12 | ||
| timed_os_statistics | No | 10, 11 and 12 | ||
| timed_statistics | No | 10, 11 and 12 | ||
| trace_enabled | No | 10, 11 and 12 | ||
| tracefile_identifier | No | 10, 11 and 12 | ||
| transactions | Yes | The default value depends on the parameter processes. | 10, 11 and 12 | |
| transactions_per_rollback_segment | No | Automic recommends using UNDO management. | 10, 11 and 12 | |
| undo_management | AUTO | Yes | Automic recommends using UNDO management. | 10, 11 and 12 |
| undo_retention | 900 | Yes |
You required an appropriate size (depending on the database size) in order to archive data with the utility AE.DB Archive (i.e. without ILMStands for Information Lifecycle Management, which refers to a wide-ranging set of strategies for administering storage systems on computing devices.). |
10, 11 and 12 |
| undo_tablespace | No | 10, 11 and 12 | ||
| unified_audit_sga_queue_size | No | 10, 11 and 12 | ||
| use_indirect_data_buffers | FALSE | No | 10, 11 and 12 | |
| user_dump_dest | No | This parameter is deprecated. | 10, 11 and 12 | |
| utl_file_dir | No | 10, 11 and 12 | ||
| workarea_size_policy | AUTO | Yes |
Automic recommends using pga_aggregate_target; thus the value AUTO must be used. |
10, 11 and 12 |
| xml_db_events | enable | No | 11 and 12 |