scripts/LJCOPY/UAT3.par

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY              FALSE
_disk_sector_size_override               TRUE
_high_priority_processes                 LMS*
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_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/uat3/UAT3/trace
backup_tape_io_slaves                    FALSE
bitmap_merge_area_size                   1048576
blank_trimming                           FALSE
buffer_pool_keep

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
buffer_pool_recycle
cell_offload_compaction                  ADAPTIVE
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                            +DATA/uat3/controlfile/current.297.941205561, +FRA/uat3/controlfile/current.1439.941205563

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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_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                                  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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
db_writer_processes                      1
dbwr_io_slaves                           0
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
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
fast_start_parallel_rollback             LOW
file_mapping                             FALSE
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                            UAT3
instance_number                          0
instance_type                            RDBMS
instant_restore                          FALSE
java_jit_enabled                         TRUE
java_max_sessionspace_size               0
java_pool_size                           0

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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_1                       LOCATION=+FRA
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
log_archive_dest_15
log_archive_dest_16
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
log_archive_dest_6
log_archive_dest_7
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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_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                       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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
log_buffer                               6987776
log_checkpoint_interval                  0
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
nls_numeric_characters
nls_sort
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                  0
optimizer_index_cost_adj                 100
optimizer_mode                           ALL_ROWS
optimizer_secure_view_merging            TRUE
optimizer_use_invisible_indexes          FALSE

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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_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/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

NAME                                     VALUE
---------------------------------------- ------------------------------------------------------------------------------------------------------------------------
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

354 rows selected.