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 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 | |
clientA closed environment within an Automation Engine system where you can create and run objects. A client name consists of a 4-digit number that must be indicated when a user logs on to the Automation Engine system. Users and their rights are also defined in clients. A particular Automation Engine object type._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 EngineThis component drives an Automation Engine system and consists of different types of server processes.. | 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_userIn the Automation Engine, a user is an instance of a User object, and generally the user is a specific person who works with Automic products. The User object is assigned a user ID and then a set of access rights to various parts of the Automation Engine system and product suite. These access rights come in the form of Automation Engine authorizations and privileges, Decision user roles and EventBase rights and ARA web application object rights. You can manage all these centrally in the ECC user management functions. See also, Unified user management._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 | |
eventAction that is triggered if particular conditions apply. It can be an Automation Engine object type or an entry in a Policy Orchestrator EventBase. | 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 | |
jobAn Automation Engine object type for a process that runs on a target system._queueA particular Automation Engine (AE) object type. In AE, a queue determines the maximum number of concurrent tasks, their priorities and the order in which tasks should be executed. In ARA, queues are containers for workflow executions that should be executed at a certain time one after another._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_stateThe state a package or a task currently is in._% | 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_calendarAn Automation Engine object type that defines a set of days based on calendar keywords. | 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 |
objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task_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_statisticsThis is a list of a task's previous runs. | 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_groupAn Automation Engine object type that integrates tasks so that they can be processed together. | 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_loginAn Automation Engine object type that stores account credentials used by agents on target systems._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_actionActions are predefined building blocks for recurring activities. They are commonly used for managing third party systems or in deployment scenarios. | No | 11 and 12 | ||
sec_protocol_error_trace_action | No | 11 and 12 | ||
sec_return_server_releaseReleases combine a set of activities and a set of packages as well as other release artifacts under a timeline (a plan including milestones and phases), which can be planned, baselined and tracked._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 |
Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support |
Copyright © 2016 Automic Software GmbH |