【文章內(nèi)容簡(jiǎn)介】 boolean FALSEresource_manager_plan string resumable_timeout integer 0rollback_segments string serial_reuse string disableservice_names string KLWLTAF, KLWLsession_cached_cursors integer 20session_max_open_files integer 10sessions integer 1105sga_max_size big integer 20Gsga_target big integer 20Gshadow_core_dump string partialshared_memory_address integer 0shared_pool_reserved_size big integer 644245094shared_pool_size big integer 0shared_server_sessions integer shared_servers integer 1skip_unusable_indexes boolean TRUEsmtp_out_server string sort_area_retained_size integer 0sort_area_size integer 65536spfile string +DATAGRP/klwl/sql92_security boolean FALSEsql_trace boolean FALSEsql_version string NATIVEsqltune_category string DEFAULTstandby_archive_dest string ?/dbs/archstandby_file_management string MANUALstar_transformation_enabled string FALSEstatistics_level string TYPICALstreams_pool_size big integer 0tape_asynch_io boolean TRUEthread integer 1timed_os_statistics integer 0timed_statistics boolean TRUEtrace_enabled boolean TRUEtracefile_identifier string transactions integer 1215transactions_per_rollback_segment integer 5undo_management string AUTOundo_retention integer 900undo_tablespace string UNDOTBS1use_indirect_data_buffers boolean FALSEuse_sigio boolean TRUEuser_dump_dest string /oracle/app/oracle/admin/KLWL/udumputl_file_dir string workarea_size_policy string AUTO 2. 財(cái)務(wù)應(yīng)用服務(wù)器系統(tǒng)資源占用在正常范圍內(nèi)。3. 物流應(yīng)用服務(wù)器二、 調(diào)整后1. 數(shù)據(jù)庫(kù)服務(wù)器 查看資源占用數(shù)據(jù)庫(kù)服務(wù)器在SGA參數(shù)調(diào)整后，兩臺(tái)數(shù)據(jù)庫(kù)服務(wù)器的CPU占用80%,頁(yè)交換都是0，內(nèi)存方面，，整體運(yùn)行正常。 修改后的Oracle參數(shù)NAME TYPE VALUE O7_DICTIONARY_ACCESSIBILITY boolean FALSEactive_instance_count integer aq_tm_processes integer 0archive_lag_target integer 0asm_diskgroups string asm_diskstring string asm_power_limit integer 1audit_file_dest string /oracle/app/oracle/admin/KLWL/adumpaudit_sys_operations boolean FALSEaudit_syslog_level string audit_trail string NONEbackground_core_dump string partialbackground_dump_dest string /oracle/app/oracle/admin/KLWL/bdumpbackup_tape_io_slaves boolean FALSEbitmap_merge_area_size integer 1048576blank_trimming boolean FALSEbuffer_pool_keep string buffer_pool_recycle string circuits integer cluster_database boolean TRUEcluster_database_instances integer 2cluster_interconnects string mit_point_strength integer 1mit_write string patible string control_file_record_keep_time integer 7control_files string +DATAGRP/klwl/, +DATAGRP/klwl/, +DATAGRP/klwl/core_dump_dest string /oracle/app/oracle/admin/KLWL/cdumpcpu_count integer 16create_bitmap_area_size integer 8388608create_stored_outlines string cursor_sharing string EXACTcursor_space_for_time boolean FALSEdb_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_block_buffers integer 0db_block_checking string FALSEdb_block_checksum string TRUEdb_block_size integer 8192db_cache_advice string ONdb_cache_size big integer 11456Mdb_create_file_dest string db_create_online_log_dest_1 string db_create_online_log_dest_2 string db_create_online_log_dest_3 string db_create_online_log_dest_4 string db_create_online_log_dest_5 string db_domain string db_file_multiblock_read_count integer 8db_file_name_convert string db_files integer 200db_flashback_retention_target integer 1440db_keep_cache_size big integer 0db_name