| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407 |
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
- 354 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/UAT3/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/uat3/UAT3/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 +DATA/uat3/controlfile/current.297.941205561, +FRA/uat3/controlfile/current.1439.941205563
- control_management_pack_access none
- core_dump_dest /u01/app/oracle/diag/rdbms/uat3/UAT3/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 +DATA
- db_create_online_log_dest_1 +REDO1
- db_create_online_log_dest_2 +REDO2
- 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 UAT3
- db_recovery_file_dest +FRA
- db_recovery_file_dest_size 1073741824000
- db_recycle_cache_size 0
- db_securefile PERMITTED
- db_ultra_safe OFF
- db_unique_name UAT3
- 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/dbhome_1/dbs/dr1UAT3.dat
- dg_broker_config_file2 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr2UAT3.dat
- dg_broker_start FALSE
- diagnostic_dest /u01/app/oracle
- disk_asynch_io TRUE
- _disk_sector_size_override TRUE
- dispatchers (PROTOCOL=TCP) (SERVICE=UAT3XDB)
- distributed_lock_timeout 60
- dml_locks 6704
- 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
- _high_priority_processes LMS*
- hi_shared_memory_address 0
- hs_autoregister TRUE
- ifile
- instance_groups
- instance_name UAT3
- 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=127.0.0.1)(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 UAT3_%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 6987776
- 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 0
- optimizer_index_cost_adj 100
- 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 1073741824
- 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 1000
- 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 26869760
- 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 UAT3
- session_cached_cursors 50
- session_max_open_files 10
- sessions 1524
- sga_max_size 5368709120
- sga_target 5368709120
- shadow_core_dump partial
- shared_memory_address 0
- shared_pool_reserved_size 43620761
- 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/dbhome_1/dbs/spfileUAT3.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 1676
- transactions_per_rollback_segment 5
- undo_management AUTO
- undo_retention 10800
- undo_tablespace UNDOTBS1
- use_indirect_data_buffers FALSE
- use_large_pages TRUE
- user_dump_dest /u01/app/oracle/diag/rdbms/uat3/UAT3/trace
- utl_file_dir
- workarea_size_policy AUTO
- xml_db_events enable
|
