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 |
|
|---|---|---|---|---|
| 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 configuration 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_database | 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 | IMMEDIATE | Yes | Currently, AE does not support the feature COMMIT BATCH for the Automation EngineDiese Komponente steuert ein Automation Engine-System. Besteht aus verschiedenen Serverprozessen.. | 11 and 12 |
| commit_point_strength | No | 10, 11 and 12 | ||
| commit_wait | 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 ManagementManagement ist der Funktionsbereich des Service Orchestrator, in dem die Verwaltung von Service Level Agreements (SLAs) durchgeführt wird. In diesem Bereich werden SLA-Definitionen erstellt, bearbeitet und gelöscht. Außerdem dient dieser Bereich auch der Verwaltung Ihrer Geschäftseinheiten. 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 ILMSteht für Information Lifecycle Management, das sich auf eine breite Palette von Strategien zur Verwaltung von Speichersystemen auf Computing-Geräten bezieht.). |
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 |