大家好，我是讯享网，很高兴认识大家。



alter system set archive_lag_target=1800 scope=spfile sid=‘’;

alter system set autotask_max_active_pdbs=64 scope=spfile sid=‘’;

alter system set awr_pdb_autoflush_enabled=TRUE scope=spfile sid=‘’;

alter system set awr_snapshot_time_offset= scope=spfile sid=‘’;

alter system set cell_offload_processing=FALSE scope=spfile sid=‘’;

alter system set control_file_record_keep_time=31 scope=spfile sid=‘’;

alter system set db_files=1024 scope=spfile sid=‘’;

alter system set db_writer_processes=4 scope=spfile sid=‘’;

alter system set deferred_segment_creation=FALSE scope=spfile sid=‘’;

alter system set enable_ddl_logging=TRUE scope=spfile sid=‘’;

alter system set enable_goldengate_replication=TRUE scope=spfile sid=‘’;

alter system set fast_start_mttr_target=300 scope=spfile sid=‘’;

alter system set filesystemio_options=‘asynch’ scope=spfile sid=‘’;

alter system set inmemory_query=disable scope=spfile sid=‘’;

alter system set job_queue_processes=4 scope=spfile sid=‘’;

alter system set large _pool_size=2G scope=spfile sid=‘’;

alter system set log_buffer=150M scope=spfile sid=‘’;

alter system set open_cursors=1500 scope=spfile sid=‘’;

alter system set optimizer_adaptive_plans=FALSE scope=spfile sid=‘’;

alter system set parallel_execution_message_size=32768 scope=spfile sid=‘’;

alter system set parallel_force_local=FALSE scope=spfile sid=‘*’;

讯享网

alter system set parallel_max_servers=【cpu_count】2  scope=spfile sid=‘’;

alter system set parallel_min_servers=【cpu_count】*20.2  scope=spfile sid=‘’;

alter system set parallel_servers_target=【parallel_max_servers】-10  scope=spfile sid=‘*’;

alter system set pga_aggregate_tazget=【物理内存（gbyte）】10%  scope=spfile sid=‘’;

alter system set pga_aggregate_limit=O  scope=spfile sid=‘’;

alter system set processes=【按需】+100  scope=spfile sid=‘’;

alter system set recovery_parallelism=4  scope=spfile sid=‘’;

alter system set result_cache_max_size=O  scope=spfile sid=‘’;

alter system set sge_max_gize=【物理内存(gbyte）】50%  scope=spfile sid=‘’;

alter system set sge_target=O  scope=spfile sid=‘’;

alter system set db_cache_advice=‘OFF’  scope=spfile sid=‘’;

alter system set db_cache_size=【sga_max_size】40%  scope=spfile sid=‘’;

alter system set shared_pool_size=【sga_max_gize】20%  scope=spfile sid=‘’;

alter system set streamg_pool_size=1g  scope=spfile sid=‘’;

alter system set undo_retention=10800  scope=spfile sid=‘’;

alter system set target_pdbs=64;  scope=spfile sid=‘’;

alter system set use_large_pages= only  scope=spfile sid=‘’;

alter system set “_adg_parselock_timeout”=550  scope=spfile sid=‘’;

alter system set “_ash_gize”=100M  scope=spfile sid=‘’;

alter system set “_clusterwide_global_transactions”=FAISE  scope=spfile sid=‘’;

alter system set “_cursor_obsolete_threshold”=1024  scope=spfile sid=‘’;

alter system set “_datafile_write_errors_crash_instance”-FALSE  scope=spfile sid=‘’;

alter system set “_external_scn_rejection_threshold_hours”=24  scope=spfile sid=‘’;

alter system set “_gc_policy_minimum”=15000  scope=spfile sid=‘’;

alter system set “_log_seqment_dump_parameter”=FALSE  scope=spfile sid=‘’;

alter system set “_log_segment_dump_patch”=FALSE  scope=spfile sid=‘’;

alter system set “_optimizer_adaptive_cursor_sharing”=FALSE  scope=spfile sid=‘’;

alter system set “_optimizer_ads_use_result_cache”=FALSE  scope=spfile sid=‘’;

alter system set “_optimizer_extended_cursor_sharing”=none  scope=spfile sid=‘’;

alter system set “_optimizer_extended_cursor_sharing_rel”=none  scope=spfile sid=‘’;

alter system set “_optimizer_gather_feedback”=FALSE   scope=spfile sid=‘’;

alter system set “_optimizer_use_feedback”=FALSE   scope=spfile sid=‘’;

alter system set “_partition_lazge_extents”=FALSE   scope=spfile sid=‘’;

alter system set “_px_use_large_pool”=TRUE   scope=spfile sid=‘’;

alter system set “_report_capture_cycle_time”=O   scope=spfile sid=‘’;

alter system set “_rollback_segment_count”=1000   scope=spfile sid=‘’;

alter system set “_serial_direct_read”=‘never’   scope=spfile sid=‘’;

alter system set “_undo_autotune”=FALSE   scope=spfile sid=‘*’;