Oracle参数文件spfile

2024年2月8日发(作者：)

commit_point_strength integer 1commit_wait stringcommit_write stringcommon_user_prefix string C##compatible string 12.2.0connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1))NAME TYPE VALUE------------------------------------ ----------- ------------------------------containers_parallel_degree integer 65535control_file_record_keep_time integer 15control_files string /data/conf_dir/current.261.972 470897control_management_pack_access string DIAGNOSTIC+TUNINGcore_dump_dest string /u01/app/oracle/diag/rdbms/gnn t/gnnt2/cdumpcpu_count integer 1create_bitmap_area_size integer 8388608create_stored_outlines stringcursor_bind_capture_destination string memory+diskNAME TYPE VALUE------------------------------------ ----------- ------------------------------cursor_invalidation string IMMEDIATEcursor_sharing string EXACTcursor_space_for_time boolean FALSEdata_guard_sync_latency integer 0data_transfer_cache_size big integer 0db_16k_cache_size big integer 0db_2k_cache_size big integer 0db_32k_cache_size big integer 0db_4k_cache_size big integer 0db_8k_cache_size big integer 0db_big_table_cache_percent_target string 0NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_block_buffers integer 0db_block_checking string FALSEdb_block_checksum string TYPICALdb_block_size integer 8192db_cache_advice string ONdb_cache_size big integer 0db_create_file_dest string /data/oradatadb_create_online_log_dest_1 stringdb_create_online_log_dest_2 stringdb_create_online_log_dest_3 stringdb_create_online_log_dest_4 stringNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_create_online_log_dest_5 stringdb_domain stringdb_file_multiblock_read_count integer 128db_file_name_convert stringdb_files integer 200db_flash_cache_file stringdb_flash_cache_size big integer 0db_flashback_retention_target integer 1440db_index_compression_inheritance string NONEdb_keep_cache_size big integer 0db_lost_write_protect string NONENAME TYPE VALUE------------------------------------ ----------- ------------------------------db_name string gnntdb_performance_profile stringdb_recovery_file_dest stringdb_recovery_file_dest_size big integer 0db_recycle_cache_size big integer 0db_securefile string PREFERREDdb_ultra_safe string OFFdb_unique_name string gnntdb_unrecoverable_scn_tracking boolean TRUEdb_writer_processes integer 1dbwr_io_slaves integer 0NAME TYPE VALUE------------------------------------ ----------- ------------------------------ddl_lock_timeout integer 0default_sharing string metadatadeferred_segment_creation boolean TRUEdg_broker_config_file1 string /u01/app/oracle/product/12.2.0

/db_1/dbs/_broker_config_file2 string /u01/app/oracle/product/12.2.0 /db_1/dbs/_broker_start boolean FALSEdiagnostic_dest string /u01/app/oracledisable_pdb_feature big integer 0disk_asynch_io boolean TRUENAME TYPE VALUE------------------------------------ ----------- ------------------------------dispatchers string (PROTOCOL=TCP) (SERVICE=gnntXD B)distributed_lock_timeout integer 60dml_locks integer 99096dnfs_batch_size integer 4096dst_upgrade_insert_conv boolean TRUEenable_automatic_maintenance_pdb boolean TRUEenable_ddl_logging boolean FALSEenable_dnfs_dispatcher boolean FALSEenable_goldengate_replication boolean FALSEenable_pluggable_database boolean TRUENAME TYPE VALUE------------------------------------ ----------- ------------------------------enabled_PDBs_on_standby string *encrypt_new_tablespaces string CLOUD_ONLYevent stringexafusion_enabled integer 1external_keystore_credential_locatio stringnfal_client stringfal_server stringfast_start_io_target integer 0fast_start_mttr_target integer 0fast_start_parallel_rollback string LOWNAME TYPE VALUE------------------------------------ ----------- ------------------------------file_mapping boolean FALSEfileio_network_adapters stringfilesystemio_options string nonefixed_date stringgcs_server_processes integer 0global_names boolean FALSEglobal_txn_processes integer 1hash_area_size integer 131072heat_map string OFFhi_shared_memory_address integer 0hs_autoregister boolean TRUENAME TYPE VALUE------------------------------------ ----------- ------------------------------ifile fileinmemory_adg_enabled boolean TRUEinmemory_clause_default stringinmemory_expressions_usage string ENABLEinmemory_force string DEFAULTinmemory_max_populate_servers integer 0inmemory_query string ENABLEinmemory_size big integer 0inmemory_trickle_repopulate_servers_ integer 1percentinmemory_virtual_columns string MANUALNAME TYPE VALUE------------------------------------ ----------- ------------------------------instance_abort_delay_time integer 0instance_groups stringinstance_mode string READ-WRITEinstance_name string gnnt2instance_number integer 2instance_type string RDBMSinstant_restore boolean FALSEjava_jit_enabled boolean TRUEjava_max_sessionspace_size integer 0java_pool_size big integer 0java_restrict string noneNAME TYPE VALUE------------------------------------ ----------- ------------------------------java_soft_sessionspace_limit integer 0job_queue_processes integer 4000large_pool_size big integer 0ldap_directory_access string NONE

ldap_directory_sysauth string nolicense_max_sessions integer 0license_max_users integer 0license_sessions_warning integer 0listener_networks stringlocal_listener string -oraagent-dummy-lock_name_space stringNAME TYPE VALUE------------------------------------ ----------- ------------------------------lock_sga boolean FALSElog_archive_config stringlog_archive_dest stringlog_archive_dest_1 string LOCATION=/acfs_archlog_archive_dest_10 stringlog_archive_dest_11 stringlog_archive_dest_12 stringlog_archive_dest_13 stringlog_archive_dest_14 stringlog_archive_dest_15 stringlog_archive_dest_16 stringNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest_17 stringlog_archive_dest_18 stringlog_archive_dest_19 stringlog_archive_dest_2 stringlog_archive_dest_20 stringlog_archive_dest_21 stringlog_archive_dest_22 stringlog_archive_dest_23 stringlog_archive_dest_24 stringlog_archive_dest_25 stringlog_archive_dest_26 stringNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest_27 stringlog_archive_dest_28 stringlog_archive_dest_29 stringlog_archive_dest_3 stringlog_archive_dest_30 stringlog_archive_dest_31 stringlog_archive_dest_4 stringlog_archive_dest_5 stringlog_archive_dest_6 stringlog_archive_dest_7 stringlog_archive_dest_8 stringNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest_9 stringlog_archive_dest_state_1 string enablelog_archive_dest_state_10 string enablelog_archive_dest_state_11 string enablelog_archive_dest_state_12 string enablelog_archive_dest_state_13 string enablelog_archive_dest_state_14 string enablelog_archive_dest_state_15 string enablelog_archive_dest_state_16 string enablelog_archive_dest_state_17 string enablelog_archive_dest_state_18 string enableNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest_state_19 string enablelog_archive_dest_state_2 string enablelog_archive_dest_state_20 string enablelog_archive_dest_state_21 string enablelog_archive_dest_state_22 string enablelog_archive_dest_state_23 string enablelog_archive_dest_state_24 string enablelog_archive_dest_state_25 string enablelog_archive_dest_state_26 string enablelog_archive_dest_state_27 string enablelog_archive_dest_state_28 string enableNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest_state_29 string enablelog_archive_dest_state_3 string enablelog_archive_dest_state_30 string enablelog_archive_dest_state_31 string enable

log_archive_dest_state_4 string enablelog_archive_dest_state_5 string enablelog_archive_dest_state_6 string enablelog_archive_dest_state_7 string enablelog_archive_dest_state_8 string enablelog_archive_dest_state_9 string enablelog_archive_duplex_dest stringNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_format string %t_%s_%_archive_max_processes integer 4log_archive_min_succeed_dest integer 1log_archive_start boolean FALSElog_archive_trace integer 0log_buffer big integer 118656Klog_checkpoint_interval integer 0log_checkpoint_timeout integer 1800log_checkpoints_to_alert boolean FALSElog_file_name_convert stringlong_module_action boolean TRUENAME TYPE VALUE------------------------------------ ----------- ------------------------------max_datapump_jobs_per_pdb integer 100max_dispatchers integermax_dump_file_size string unlimitedmax_idle_time integer 0max_iops integer 0max_mbps integer 0max_pdbs integer 4098max_shared_servers integermax_string_size string STANDARDmemory_max_target big integer 0memory_target big integer 0NAME TYPE VALUE------------------------------------ ----------- ------------------------------nls_calendar string GREGORIANnls_comp string BINARYnls_currency string $nls_date_format string DD-MON-RRnls_date_language string AMERICANnls_dual_currency string $nls_iso_currency string AMERICAnls_language string AMERICANnls_length_semantics string BYTEnls_nchar_conv_excp string FALSEnls_numeric_characters string .,NAME TYPE VALUE------------------------------------ ----------- ------------------------------nls_sort string BINARYnls_territory string AMERICAnls_time_format string AMnls_time_tz_format string AM TZRnls_timestamp_format string DD-MON-RR AMnls_timestamp_tz_format string DD-MON-RR AM TZRnoncdb_compatible boolean FALSEobject_cache_max_size_percent integer 10object_cache_optimal_size integer 10240000ofs_threads integer 4olap_page_pool_size big integer 0NAME TYPE VALUE------------------------------------ ----------- ------------------------------one_step_plugin_for_pdb_with_tde boolean FALSEopen_cursors integer 300open_links integer 4open_links_per_instance integer 4optimizer_adaptive_plans boolean TRUEoptimizer_adaptive_reporting_only boolean FALSEoptimizer_adaptive_statistics boolean FALSEoptimizer_capture_sql_plan_baselines boolean FALSEoptimizer_dynamic_sampling integer 2optimizer_features_enable string 12.2.0.1optimizer_index_caching integer 0NAME TYPE VALUE------------------------------------ ----------- ------------------------------optimizer_index_cost_adj integer 100optimizer_inmemory_aware boolean TRUEoptimizer_mode string ALL_ROWSoptimizer_secure_view_merging boolean TRUE

optimizer_use_invisible_indexes boolean FALSEoptimizer_use_pending_statistics boolean FALSEoptimizer_use_sql_plan_baselines boolean TRUEos_authent_prefix string ops$os_roles boolean FALSEoutbound_dblink_protocols string ALLparallel_adaptive_multi_user boolean FALSENAME TYPE VALUE------------------------------------ ----------- ------------------------------parallel_degree_limit string CPUparallel_degree_policy string MANUALparallel_execution_message_size integer 16384parallel_force_local boolean FALSEparallel_instance_group stringparallel_max_servers integer 40parallel_min_percent integer 0parallel_min_servers integer 4parallel_min_time_threshold string AUTOparallel_servers_target integer 16parallel_threads_per_cpu integer 2NAME TYPE VALUE------------------------------------ ----------- ------------------------------pdb_file_name_convert stringpdb_lockdown stringpdb_os_credential stringpermit_92_wrap_format boolean TRUEpga_aggregate_limit big integer 45000Mpga_aggregate_target big integer 13107Mplscope_settings string IDENTIFIERS:NONEplsql_ccflags stringplsql_code_type string INTERPRETEDplsql_debug boolean FALSEplsql_optimize_level integer 2NAME TYPE VALUE------------------------------------ ----------- ------------------------------plsql_v2_compatibility boolean FALSEplsql_warnings string DISABLE:ALLpre_page_sga boolean TRUEprocesses integer 15000processor_group_name stringquery_rewrite_enabled string TRUEquery_rewrite_integrity string enforcedrdbms_server_dn stringread_only_open_delayed boolean FALSErecovery_parallelism integer 0recyclebin string onNAME TYPE VALUE------------------------------------ ----------- ------------------------------redo_transport_user stringremote_dependencies_mode string TIMESTAMPremote_listener stringremote_login_passwordfile string EXCLUSIVEremote_os_authent boolean FALSEremote_os_roles boolean FALSEremote_recovery_file_dest stringreplication_dependency_tracking boolean TRUEresource_limit boolean TRUEresource_manage_goldengate boolean FALSEresource_manager_cpu_allocation integer 1NAME TYPE VALUE------------------------------------ ----------- ------------------------------resource_manager_plan stringresult_cache_max_result integer 5result_cache_max_size big integer 268704Kresult_cache_mode string MANUALresult_cache_remote_expiration integer 0resumable_timeout integer 0rollback_segments stringsec_case_sensitive_logon boolean TRUEsec_max_failed_login_attempts integer 3sec_protocol_error_further_action string (DROP,3)sec_protocol_error_trace_action string TRACENAME TYPE VALUE------------------------------------ ----------- ------------------------------sec_return_server_release_banner boolean FALSEserial_reuse string disableservice_names string gnntsession_cached_cursors integer 50