NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ O7_DICTIONARY_ACCESSIBILITY FALSE 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_sys_operations FALSE audit_syslog_level 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ cell_offload_decryption TRUE cell_offload_parameters cell_offload_plan_display AUTO cell_offload_processing TRUE cell_offloadgroup_name 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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_flash_cache_file db_flash_cache_size 0 db_flashback_retention_target 1440 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 db_writer_processes 1 dbwr_io_slaves 0 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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 file_mapping FALSE NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ fileio_network_adapters 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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_1 LOCATION=+FRA 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ log_archive_dest_17 log_archive_dest_18 log_archive_dest_19 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ log_archive_dest_8 log_archive_dest_9 log_archive_dest_state_1 enable 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_2 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ log_archive_dest_state_27 enable log_archive_dest_state_28 enable log_archive_dest_state_29 enable log_archive_dest_state_3 enable log_archive_dest_state_30 enable log_archive_dest_state_31 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ log_checkpoint_timeout 1800 log_checkpoints_to_alert FALSE 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 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ nls_territory AMERICA nls_time_format nls_time_tz_format nls_timestamp_format nls_timestamp_tz_format 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ sga_target 12884901888 shadow_core_dump partial shared_memory_address 0 shared_pool_reserved_size 85563801 shared_pool_size 0 shared_server_sessions shared_servers 1 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 NAME VALUE ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ 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 352 rows selected.