---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 352 rows selected. active_instance_count aq_tm_processes 1 archive_lag_target 1800 asm_diskgroups asm_diskstring asm_power_limit 1 asm_preferred_read_failure_groups audit_file_dest /u01/app/oracle/admin/SIT/adump audit_syslog_level audit_sys_operations FALSE audit_trail DB awr_snapshot_time_offset 0 background_core_dump partial background_dump_dest /u01/app/oracle/diag/rdbms/sit/SIT/trace backup_tape_io_slaves FALSE bitmap_merge_area_size 1048576 blank_trimming FALSE buffer_pool_keep buffer_pool_recycle cell_offload_compaction ADAPTIVE cell_offload_decryption TRUE cell_offloadgroup_name cell_offload_parameters cell_offload_plan_display AUTO cell_offload_processing TRUE circuits client_result_cache_lag 3000 client_result_cache_size 0 clonedb FALSE cluster_database FALSE cluster_database_instances 1 cluster_interconnects commit_logging commit_point_strength 1 commit_wait commit_write compatible 11.2.0.4.0 control_file_record_keep_time 60 control_files +DBFILES1/sit/controlfile/current.364.843403209, +FRA/sit/controlfile/current.313.843403209 control_management_pack_access NONE core_dump_dest /u01/app/oracle/diag/rdbms/sit/SIT/cdump cpu_count 4 create_bitmap_area_size 8388608 create_stored_outlines cursor_bind_capture_destination memory+disk cursor_sharing EXACT cursor_space_for_time FALSE db_16k_cache_size 0 db_2k_cache_size 0 db_32k_cache_size 0 db_4k_cache_size 0 db_8k_cache_size 0 db_block_buffers 0 db_block_checking FALSE db_block_checksum TYPICAL db_block_size 8192 db_cache_advice ON db_cache_size 0 db_create_file_dest +DBFILES1 db_create_online_log_dest_1 +DBFILES1 db_create_online_log_dest_2 +FRA db_create_online_log_dest_3 db_create_online_log_dest_4 db_create_online_log_dest_5 db_domain db_file_multiblock_read_count 128 db_file_name_convert db_files 200 db_flashback_retention_target 1440 db_flash_cache_file db_flash_cache_size 0 db_keep_cache_size 0 db_lost_write_protect NONE db_name SIT db_recovery_file_dest +FRA db_recovery_file_dest_size 322122547200 db_recycle_cache_size 0 db_securefile ALWAYS db_ultra_safe OFF db_unique_name SIT db_unrecoverable_scn_tracking TRUE dbwr_io_slaves 0 db_writer_processes 1 ddl_lock_timeout 0 deferred_segment_creation TRUE dg_broker_config_file1 /u01/app/oracle/product/11.2.0/db_1/dbs/dr1SIT.dat dg_broker_config_file2 /u01/app/oracle/product/11.2.0/db_1/dbs/dr2SIT.dat dg_broker_start FALSE diagnostic_dest /u01/app/oracle disk_asynch_io TRUE dispatchers (PROTOCOL=TCP) (SERVICE=SITXDB) distributed_lock_timeout 60 dml_locks 4064 dnfs_batch_size 4096 dst_upgrade_insert_conv TRUE enable_ddl_logging FALSE enable_goldengate_replication FALSE event fal_client fal_server fast_start_io_target 0 fast_start_mttr_target 0 fast_start_parallel_rollback LOW fileio_network_adapters file_mapping FALSE filesystemio_options none fixed_date gcs_server_processes 0 global_context_pool_size global_names FALSE global_txn_processes 1 hash_area_size 131072 hi_shared_memory_address 0 hs_autoregister TRUE ifile instance_groups instance_name SIT instance_number 0 instance_type RDBMS instant_restore FALSE java_jit_enabled TRUE java_max_sessionspace_size 0 java_pool_size 0 java_restrict none java_soft_sessionspace_limit 0 job_queue_processes 1000 large_pool_size 0 ldap_directory_access NONE ldap_directory_sysauth no license_max_sessions 0 license_max_users 0 license_sessions_warning 0 listener_networks local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=10.170.3.135)(PORT=1521)) lock_name_space lock_sga FALSE log_archive_config log_archive_dest log_archive_dest_10 log_archive_dest_11 log_archive_dest_12 log_archive_dest_13 log_archive_dest_14 log_archive_dest_15 log_archive_dest_16 log_archive_dest_17 log_archive_dest_18 log_archive_dest_19 log_archive_dest_1 LOCATION=+FRA log_archive_dest_2 log_archive_dest_20 log_archive_dest_21 log_archive_dest_22 log_archive_dest_23 log_archive_dest_24 log_archive_dest_25 log_archive_dest_26 log_archive_dest_27 log_archive_dest_28 log_archive_dest_29 log_archive_dest_3 log_archive_dest_30 log_archive_dest_31 log_archive_dest_4 log_archive_dest_5 log_archive_dest_6 log_archive_dest_7 log_archive_dest_8 log_archive_dest_9 log_archive_dest_state_10 enable log_archive_dest_state_11 enable log_archive_dest_state_12 enable log_archive_dest_state_13 enable log_archive_dest_state_14 enable log_archive_dest_state_15 enable log_archive_dest_state_16 enable log_archive_dest_state_17 enable log_archive_dest_state_18 enable log_archive_dest_state_19 enable log_archive_dest_state_1 enable log_archive_dest_state_20 enable log_archive_dest_state_21 enable log_archive_dest_state_22 enable log_archive_dest_state_23 enable log_archive_dest_state_24 enable log_archive_dest_state_25 enable log_archive_dest_state_26 enable log_archive_dest_state_27 enable log_archive_dest_state_28 enable log_archive_dest_state_29 enable log_archive_dest_state_2 enable log_archive_dest_state_30 enable log_archive_dest_state_31 enable log_archive_dest_state_3 enable log_archive_dest_state_4 enable log_archive_dest_state_5 enable log_archive_dest_state_6 enable log_archive_dest_state_7 enable log_archive_dest_state_8 enable log_archive_dest_state_9 enable log_archive_duplex_dest log_archive_format %t_%s_%r.arch log_archive_local_first TRUE log_archive_max_processes 4 log_archive_min_succeed_dest 1 log_archive_start FALSE log_archive_trace 0 log_buffer 6979584 log_checkpoint_interval 0 log_checkpoints_to_alert FALSE log_checkpoint_timeout 1800 log_file_name_convert max_dispatchers max_dump_file_size unlimited max_enabled_roles 150 max_shared_servers memory_max_target 0 memory_target 0 NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE NAME VALUE nls_calendar nls_comp BINARY nls_currency nls_date_format nls_date_language nls_dual_currency nls_iso_currency nls_language AMERICAN nls_length_semantics BYTE nls_nchar_conv_excp FALSE nls_numeric_characters nls_sort nls_territory AMERICA nls_time_format nls_timestamp_format nls_timestamp_tz_format nls_time_tz_format O7_DICTIONARY_ACCESSIBILITY FALSE object_cache_max_size_percent 10 object_cache_optimal_size 102400 olap_page_pool_size 0 open_cursors 2000 open_links 4 open_links_per_instance 4 optimizer_capture_sql_plan_baselines FALSE optimizer_dynamic_sampling 2 optimizer_features_enable 11.2.0.4 optimizer_index_caching 100 optimizer_index_cost_adj 1 optimizer_mode ALL_ROWS optimizer_secure_view_merging TRUE optimizer_use_invisible_indexes FALSE optimizer_use_pending_statistics FALSE optimizer_use_sql_plan_baselines TRUE os_authent_prefix ops$ os_roles FALSE parallel_adaptive_multi_user TRUE parallel_automatic_tuning FALSE parallel_degree_limit CPU parallel_degree_policy MANUAL parallel_execution_message_size 16384 parallel_force_local FALSE parallel_instance_group parallel_io_cap_enabled FALSE parallel_max_servers 160 parallel_min_percent 0 parallel_min_servers 0 parallel_min_time_threshold AUTO parallel_server FALSE parallel_server_instances 1 parallel_servers_target 64 parallel_threads_per_cpu 2 permit_92_wrap_format TRUE pga_aggregate_target 1525678080 plscope_settings IDENTIFIERS:NONE plsql_ccflags plsql_code_type INTERPRETED plsql_debug FALSE plsql_optimize_level 2 plsql_v2_compatibility FALSE plsql_warnings DISABLE:ALL pre_page_sga FALSE processes 600 processor_group_name query_rewrite_enabled TRUE query_rewrite_integrity enforced rdbms_server_dn read_only_open_delayed FALSE recovery_parallelism 0 recyclebin on redo_transport_user remote_dependencies_mode TIMESTAMP remote_listener remote_login_passwordfile EXCLUSIVE remote_os_authent FALSE remote_os_roles FALSE replication_dependency_tracking TRUE resource_limit FALSE resource_manager_cpu_allocation 4 resource_manager_plan result_cache_max_result 5 result_cache_max_size 64454656 result_cache_mode MANUAL result_cache_remote_expiration 0 resumable_timeout 0 rollback_segments sec_case_sensitive_logon TRUE sec_max_failed_login_attempts 10 sec_protocol_error_further_action CONTINUE sec_protocol_error_trace_action TRACE sec_return_server_release_banner FALSE serial_reuse disable service_names SIT session_cached_cursors 50 session_max_open_files 10 sessions 924 sga_max_size 12884901888 sga_target 12884901888 shadow_core_dump partial shared_memory_address 0 shared_pool_reserved_size 85563801 shared_pool_size 0 shared_servers 1 shared_server_sessions skip_unusable_indexes TRUE smtp_out_server sort_area_retained_size 0 sort_area_size 65536 spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfileSIT.ora sql92_security FALSE sql_trace FALSE sqltune_category DEFAULT standby_archive_dest ?/dbs/arch standby_file_management MANUAL star_transformation_enabled FALSE statistics_level TYPICAL streams_pool_size 0 tape_asynch_io TRUE thread 0 timed_os_statistics 0 timed_statistics TRUE trace_enabled TRUE tracefile_identifier transactions 1016 transactions_per_rollback_segment 5 undo_management AUTO undo_retention 900 undo_tablespace UNDOTBS1 use_indirect_data_buffers FALSE use_large_pages TRUE user_dump_dest /u01/app/oracle/diag/rdbms/sit/SIT/trace utl_file_dir workarea_size_policy AUTO xml_db_events enable