[oracle@dev ~]$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 16 13:17:48 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> SET PAGESIZE 60
SET LINESIZE 300
COLUMN name FORMAT A35
COLUMN value FORMAT A50
SELECT p.name,
p.type,
p.value
FROM v$parameter p
ORDER BY p.name
/
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY 1 FALSE
active_instance_count 3
aq_tm_processes 3 1
archive_lag_target 3 0
asm_diskgroups 2
asm_diskstring 2
asm_power_limit 3 1
asm_preferred_read_failure_groups 2
audit_file_dest 2 /u01/app/oracle/admin/HRPRD/adump
audit_sys_operations 1 FALSE
audit_syslog_level 2
audit_trail 2 DB
awr_snapshot_time_offset 3 0
background_core_dump 2 partial
background_dump_dest 2 /u01/app/oracle/diag/rdbms/hrprd/HRPRD1/trace
backup_tape_io_slaves 1 FALSE
bitmap_merge_area_size 3 1048576
blank_trimming 1 FALSE
buffer_pool_keep 2
buffer_pool_recycle 2
cell_offload_compaction 2 ADAPTIVE
cell_offload_decryption 1 TRUE
cell_offload_parameters 2
cell_offload_plan_display 2 AUTO
cell_offload_processing 1 TRUE
circuits 3
client_result_cache_lag 6 3000
client_result_cache_size 6 0
clonedb 1 FALSE
cluster_database 1 TRUE
cluster_database_instances 3 2
cluster_interconnects 2
commit_logging 2
commit_point_strength 3 1
commit_wait 2
commit_write 2
compatible 2 11.2.0.0.0
control_file_record_keep_time 3 7
control_files 2 +ORADB/hrprd/controlfile/current.412.852580449, +
ORA_FRA/hrprd/controlfile/current.273.852580449
control_management_pack_access 2 DIAGNOSTIC+TUNING
core_dump_dest 2 /u01/app/oracle/diag/rdbms/hrprd/HRPRD1/cdump
cpu_count 3 32
create_bitmap_area_size 3 8388608
create_stored_outlines 2
cursor_bind_capture_destination 2 memory+disk
cursor_sharing 2 EXACT
cursor_space_for_time 1 FALSE
db_16k_cache_size 6 0
db_2k_cache_size 6 0
db_32k_cache_size 6 0
db_4k_cache_size 6 0
db_8k_cache_size 6 0
db_block_buffers 3 0
db_block_checking 2 FALSE
db_block_checksum 2 TYPICAL
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
db_block_size 3 8192
db_cache_advice 2 ON
db_cache_size 6 0
db_create_file_dest 2 +ORADB
db_create_online_log_dest_1 2
db_create_online_log_dest_2 2
db_create_online_log_dest_3 2
db_create_online_log_dest_4 2
db_create_online_log_dest_5 2
db_domain 2
db_file_multiblock_read_count 3 128
db_file_name_convert 2 +ORADB/HRDRD, +ORADB/HRPRD, +ORAFRA/HRDRD, +OR
A_FRA/HRPRD
db_files 3 200
db_flash_cache_file 2
db_flash_cache_size 6 0
db_flashback_retention_target 3 480
db_keep_cache_size 6 0
db_lost_write_protect 2 NONE
db_name 2 HRPRD
db_recovery_file_dest 2 +ORAFRA
db_recovery_file_dest_size 6 429496729600
db_recycle_cache_size 6 0
db_securefile 2 PERMITTED
db_ultra_safe 2 OFF
db_unique_name 2 HRPRD
db_unrecoverable_scn_tracking 1 TRUE
db_writer_processes 3 4
dbwr_io_slaves 3 0
ddl_lock_timeout 3 0
deferred_segment_creation 1 TRUE
dg_broker_config_file1 2 /u01/app/oracle/product/11.2.0/db_1/dbs/dr1HRPRD.d
at
dg_broker_config_file2 2 /u01/app/oracle/product/11.2.0/db_1/dbs/dr2HRPRD.d
at
dg_broker_start 1 FALSE
diagnostic_dest 2 /u01/app/oracle
disk_asynch_io 1 TRUE
dispatchers 2 (PROTOCOL=TCP) (SERVICE=HRPRDXDB)
distributed_lock_timeout 3 60
dml_locks 3 8024
dst_upgrade_insert_conv 1 TRUE
enable_ddl_logging 1 FALSE
event 2
fal_client 2 HRPRD
fal_server 2 HRDRD
fast_start_io_target 3 0
fast_start_mttr_target 3 0
fast_start_parallel_rollback 2 LOW
file_mapping 1 FALSE
fileio_network_adapters 2
filesystemio_options 2 none
fixed_date 2
gcs_server_processes 3 3
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
global_context_pool_size 2
global_names 1 FALSE
global_txn_processes 3 1
hash_area_size 3 131072
hi_shared_memory_address 3 0
hs_autoregister 1 TRUE
ifile 4
instance_groups 2
instance_name 2 HRPRD1
instance_number 3 1
instance_type 2 RDBMS
java_jit_enabled 1 TRUE
java_max_sessionspace_size 3 0
java_pool_size 6 0
java_soft_sessionspace_limit 3 0
job_queue_processes 3 1000
large_pool_size 6 0
ldap_directory_access 2 NONE
ldap_directory_sysauth 2 no
license_max_sessions 3 0
license_max_users 3 0
license_sessions_warning 3 0
listener_networks 2
local_listener 2 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP
)(HOST=192.168.1.160)(PORT=1521))))
lock_name_space 2
lock_sga 1 FALSE
log_archive_config 2 DG_CONFIG=(HRPRD, HRDRD)
log_archive_dest 2
log_archive_dest_1 2 location=+ORA_ARCH VALID_FOR=(ALL_LOGFILES,ALL_ROL
ES) db_unique_name=HRPRD
log_archive_dest_10 2
log_archive_dest_11 2
log_archive_dest_12 2
log_archive_dest_13 2
log_archive_dest_14 2
log_archive_dest_15 2
log_archive_dest_16 2
log_archive_dest_17 2
log_archive_dest_18 2
log_archive_dest_19 2
log_archive_dest_2 2 service=HRDRD arch valid_for=(online_logfiles,prim
ary_role) db_unique_name=HRDRD
log_archive_dest_20 2
log_archive_dest_21 2
log_archive_dest_22 2
log_archive_dest_23 2
log_archive_dest_24 2
log_archive_dest_25 2
log_archive_dest_26 2
log_archive_dest_27 2
log_archive_dest_28 2
log_archive_dest_29 2
log_archive_dest_3 2
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
log_archive_dest_30 2
log_archive_dest_31 2
log_archive_dest_4 2
log_archive_dest_5 2
log_archive_dest_6 2
log_archive_dest_7 2
log_archive_dest_8 2
log_archive_dest_9 2
log_archive_dest_state_1 2 enable
log_archive_dest_state_10 2 enable
log_archive_dest_state_11 2 enable
log_archive_dest_state_12 2 enable
log_archive_dest_state_13 2 enable
log_archive_dest_state_14 2 enable
log_archive_dest_state_15 2 enable
log_archive_dest_state_16 2 enable
log_archive_dest_state_17 2 enable
log_archive_dest_state_18 2 enable
log_archive_dest_state_19 2 enable
log_archive_dest_state_2 2 ENABLE
log_archive_dest_state_20 2 enable
log_archive_dest_state_21 2 enable
log_archive_dest_state_22 2 enable
log_archive_dest_state_23 2 enable
log_archive_dest_state_24 2 enable
log_archive_dest_state_25 2 enable
log_archive_dest_state_26 2 enable
log_archive_dest_state_27 2 enable
log_archive_dest_state_28 2 enable
log_archive_dest_state_29 2 enable
log_archive_dest_state_3 2 enable
log_archive_dest_state_30 2 enable
log_archive_dest_state_31 2 enable
log_archive_dest_state_4 2 enable
log_archive_dest_state_5 2 enable
log_archive_dest_state_6 2 enable
log_archive_dest_state_7 2 enable
log_archive_dest_state_8 2 enable
log_archive_dest_state_9 2 enable
log_archive_duplex_dest 2
log_archive_format 2 %t_%s_%r.dbf
log_archive_local_first 1 TRUE
log_archive_max_processes 3 4
log_archive_min_succeed_dest 3 1
log_archive_start 1 FALSE
log_archive_trace 3 0
log_buffer 3 20946944
log_checkpoint_interval 3 0
log_checkpoint_timeout 3 1800
log_checkpoints_to_alert 1 FALSE
log_file_name_convert 2 +ORADB/HRDRD, +ORADB/HRPRD, +ORAFRA/HRDRD, +OR
A_FRA/HRPRD
max_dispatchers 3
max_dump_file_size 2 unlimited
max_enabled_roles 3 150
max_shared_servers 3
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
memory_max_target 6 17179869184
memory_target 6 17179869184
nls_calendar 2
nls_comp 2 BINARY
nls_currency 2
nls_date_format 2
nls_date_language 2
nls_dual_currency 2
nls_iso_currency 2
nls_language 2 AMERICAN
nls_length_semantics 2 BYTE
nls_nchar_conv_excp 2 FALSE
nls_numeric_characters 2
nls_sort 2
nls_territory 2 AMERICA
nls_time_format 2
nls_time_tz_format 2
nls_timestamp_format 2
nls_timestamp_tz_format 2
object_cache_max_size_percent 3 10
object_cache_optimal_size 3 102400
olap_page_pool_size 6 0
open_cursors 3 300
open_links 3 4
open_links_per_instance 3 4
optimizer_capture_sql_plan_baseline 1 FALSE
s
optimizer_dynamic_sampling 3 2
optimizer_features_enable 2 11.2.0.3
optimizer_index_caching 3 0
optimizer_index_cost_adj 3 100
optimizer_mode 2 ALL_ROWS
optimizer_secure_view_merging 1 TRUE
optimizer_use_invisible_indexes 1 FALSE
optimizer_use_pending_statistics 1 FALSE
optimizer_use_sql_plan_baselines 1 TRUE
os_authent_prefix 2 ops$
os_roles 1 FALSE
parallel_adaptive_multi_user 1 TRUE
parallel_automatic_tuning 1 FALSE
parallel_degree_limit 2 CPU
parallel_degree_policy 2 MANUAL
parallel_execution_message_size 3 16384
parallel_force_local 1 FALSE
parallel_instance_group 2
parallel_io_cap_enabled 1 FALSE
parallel_max_servers 3 1185
parallel_min_percent 3 0
parallel_min_servers 3 0
parallel_min_time_threshold 2 AUTO
parallel_server 1 TRUE
parallel_server_instances 3 2
parallel_servers_target 3 512
parallel_threads_per_cpu 3 2
permit_92_wrap_format 1 TRUE
pga_aggregate_target 6 0
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
plscope_settings 2 IDENTIFIERS:NONE
plsql_ccflags 2
plsql_code_type 2 INTERPRETED
plsql_debug 1 FALSE
plsql_optimize_level 3 2
plsql_v2_compatibility 1 FALSE
plsql_warnings 2 DISABLE:ALL
pre_page_sga 1 FALSE
processes 3 1200
processor_group_name 2
query_rewrite_enabled 2 TRUE
query_rewrite_integrity 2 enforced
rdbms_server_dn 2
read_only_open_delayed 1 FALSE
recovery_parallelism 3 0
recyclebin 2 on
redo_transport_user 2
remote_dependencies_mode 2 TIMESTAMP
remote_listener 2 hrmsdcdb-scan:1525
remote_login_passwordfile 2 EXCLUSIVE
remote_os_authent 1 FALSE
remote_os_roles 1 FALSE
replication_dependency_tracking 1 TRUE
resource_limit 1 FALSE
resource_manager_cpu_allocation 3 32
resource_manager_plan 2
result_cache_max_result 3 5
result_cache_max_size 6 42958848
result_cache_mode 2 MANUAL
result_cache_remote_expiration 3 0
resumable_timeout 3 0
rollback_segments 2
sec_case_sensitive_logon 1 TRUE
sec_max_failed_login_attempts 3 10
sec_protocol_error_further_action 2 CONTINUE
sec_protocol_error_trace_action 2 TRACE
sec_return_server_release_banner 1 FALSE
serial_reuse 2 disable
service_names 2 HRPRD
session_cached_cursors 3 50
session_max_open_files 3 10
sessions 3 1824
sga_max_size 6 17179869184
sga_target 6 0
shadow_core_dump 2 partial
shared_memory_address 3 0
shared_pool_reserved_size 6 273468620
shared_pool_size 6 0
shared_server_sessions 3
shared_servers 3 1
skip_unusable_indexes 1 TRUE
smtp_out_server 2
sort_area_retained_size 3 0
sort_area_size 3 65536
spfile 2 +ORADB/hrprd/spfilehrprd.ora
sql92_security 1 FALSE
sql_trace 1 FALSE
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
sqltune_category 2 DEFAULT
standby_archive_dest 2 ?/dbs/arch
standby_file_management 2 AUTO
star_transformation_enabled 2 FALSE
statistics_level 2 TYPICAL
streams_pool_size 6 0
tape_asynch_io 1 TRUE
thread 3 1
timed_os_statistics 3 0
timed_statistics 1 TRUE
trace_enabled 1 TRUE
tracefile_identifier 2
transactions 3 2006
transactions_per_rollback_segment 3 5
undo_management 2 AUTO
undo_retention 3 900
undo_tablespace 2 PSUNDOTS1
use_indirect_data_buffers 1 FALSE
use_large_pages 2 TRUE
user_dump_dest 2 /u01/app/oracle/diag/rdbms/hrprd/HRPRD1/trace
utl_file_dir 2
workarea_size_policy 2 AUTO
xml_db_events 2 enable
347 rows selected.
SQL>
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 16 13:17:48 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> SET PAGESIZE 60
SET LINESIZE 300
COLUMN name FORMAT A35
COLUMN value FORMAT A50
SELECT p.name,
p.type,
p.value
FROM v$parameter p
ORDER BY p.name
/
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY 1 FALSE
active_instance_count 3
aq_tm_processes 3 1
archive_lag_target 3 0
asm_diskgroups 2
asm_diskstring 2
asm_power_limit 3 1
asm_preferred_read_failure_groups 2
audit_file_dest 2 /u01/app/oracle/admin/HRPRD/adump
audit_sys_operations 1 FALSE
audit_syslog_level 2
audit_trail 2 DB
awr_snapshot_time_offset 3 0
background_core_dump 2 partial
background_dump_dest 2 /u01/app/oracle/diag/rdbms/hrprd/HRPRD1/trace
backup_tape_io_slaves 1 FALSE
bitmap_merge_area_size 3 1048576
blank_trimming 1 FALSE
buffer_pool_keep 2
buffer_pool_recycle 2
cell_offload_compaction 2 ADAPTIVE
cell_offload_decryption 1 TRUE
cell_offload_parameters 2
cell_offload_plan_display 2 AUTO
cell_offload_processing 1 TRUE
circuits 3
client_result_cache_lag 6 3000
client_result_cache_size 6 0
clonedb 1 FALSE
cluster_database 1 TRUE
cluster_database_instances 3 2
cluster_interconnects 2
commit_logging 2
commit_point_strength 3 1
commit_wait 2
commit_write 2
compatible 2 11.2.0.0.0
control_file_record_keep_time 3 7
control_files 2 +ORADB/hrprd/controlfile/current.412.852580449, +
ORA_FRA/hrprd/controlfile/current.273.852580449
control_management_pack_access 2 DIAGNOSTIC+TUNING
core_dump_dest 2 /u01/app/oracle/diag/rdbms/hrprd/HRPRD1/cdump
cpu_count 3 32
create_bitmap_area_size 3 8388608
create_stored_outlines 2
cursor_bind_capture_destination 2 memory+disk
cursor_sharing 2 EXACT
cursor_space_for_time 1 FALSE
db_16k_cache_size 6 0
db_2k_cache_size 6 0
db_32k_cache_size 6 0
db_4k_cache_size 6 0
db_8k_cache_size 6 0
db_block_buffers 3 0
db_block_checking 2 FALSE
db_block_checksum 2 TYPICAL
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
db_block_size 3 8192
db_cache_advice 2 ON
db_cache_size 6 0
db_create_file_dest 2 +ORADB
db_create_online_log_dest_1 2
db_create_online_log_dest_2 2
db_create_online_log_dest_3 2
db_create_online_log_dest_4 2
db_create_online_log_dest_5 2
db_domain 2
db_file_multiblock_read_count 3 128
db_file_name_convert 2 +ORADB/HRDRD, +ORADB/HRPRD, +ORAFRA/HRDRD, +OR
A_FRA/HRPRD
db_files 3 200
db_flash_cache_file 2
db_flash_cache_size 6 0
db_flashback_retention_target 3 480
db_keep_cache_size 6 0
db_lost_write_protect 2 NONE
db_name 2 HRPRD
db_recovery_file_dest 2 +ORAFRA
db_recovery_file_dest_size 6 429496729600
db_recycle_cache_size 6 0
db_securefile 2 PERMITTED
db_ultra_safe 2 OFF
db_unique_name 2 HRPRD
db_unrecoverable_scn_tracking 1 TRUE
db_writer_processes 3 4
dbwr_io_slaves 3 0
ddl_lock_timeout 3 0
deferred_segment_creation 1 TRUE
dg_broker_config_file1 2 /u01/app/oracle/product/11.2.0/db_1/dbs/dr1HRPRD.d
at
dg_broker_config_file2 2 /u01/app/oracle/product/11.2.0/db_1/dbs/dr2HRPRD.d
at
dg_broker_start 1 FALSE
diagnostic_dest 2 /u01/app/oracle
disk_asynch_io 1 TRUE
dispatchers 2 (PROTOCOL=TCP) (SERVICE=HRPRDXDB)
distributed_lock_timeout 3 60
dml_locks 3 8024
dst_upgrade_insert_conv 1 TRUE
enable_ddl_logging 1 FALSE
event 2
fal_client 2 HRPRD
fal_server 2 HRDRD
fast_start_io_target 3 0
fast_start_mttr_target 3 0
fast_start_parallel_rollback 2 LOW
file_mapping 1 FALSE
fileio_network_adapters 2
filesystemio_options 2 none
fixed_date 2
gcs_server_processes 3 3
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
global_context_pool_size 2
global_names 1 FALSE
global_txn_processes 3 1
hash_area_size 3 131072
hi_shared_memory_address 3 0
hs_autoregister 1 TRUE
ifile 4
instance_groups 2
instance_name 2 HRPRD1
instance_number 3 1
instance_type 2 RDBMS
java_jit_enabled 1 TRUE
java_max_sessionspace_size 3 0
java_pool_size 6 0
java_soft_sessionspace_limit 3 0
job_queue_processes 3 1000
large_pool_size 6 0
ldap_directory_access 2 NONE
ldap_directory_sysauth 2 no
license_max_sessions 3 0
license_max_users 3 0
license_sessions_warning 3 0
listener_networks 2
local_listener 2 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP
)(HOST=192.168.1.160)(PORT=1521))))
lock_name_space 2
lock_sga 1 FALSE
log_archive_config 2 DG_CONFIG=(HRPRD, HRDRD)
log_archive_dest 2
log_archive_dest_1 2 location=+ORA_ARCH VALID_FOR=(ALL_LOGFILES,ALL_ROL
ES) db_unique_name=HRPRD
log_archive_dest_10 2
log_archive_dest_11 2
log_archive_dest_12 2
log_archive_dest_13 2
log_archive_dest_14 2
log_archive_dest_15 2
log_archive_dest_16 2
log_archive_dest_17 2
log_archive_dest_18 2
log_archive_dest_19 2
log_archive_dest_2 2 service=HRDRD arch valid_for=(online_logfiles,prim
ary_role) db_unique_name=HRDRD
log_archive_dest_20 2
log_archive_dest_21 2
log_archive_dest_22 2
log_archive_dest_23 2
log_archive_dest_24 2
log_archive_dest_25 2
log_archive_dest_26 2
log_archive_dest_27 2
log_archive_dest_28 2
log_archive_dest_29 2
log_archive_dest_3 2
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
log_archive_dest_30 2
log_archive_dest_31 2
log_archive_dest_4 2
log_archive_dest_5 2
log_archive_dest_6 2
log_archive_dest_7 2
log_archive_dest_8 2
log_archive_dest_9 2
log_archive_dest_state_1 2 enable
log_archive_dest_state_10 2 enable
log_archive_dest_state_11 2 enable
log_archive_dest_state_12 2 enable
log_archive_dest_state_13 2 enable
log_archive_dest_state_14 2 enable
log_archive_dest_state_15 2 enable
log_archive_dest_state_16 2 enable
log_archive_dest_state_17 2 enable
log_archive_dest_state_18 2 enable
log_archive_dest_state_19 2 enable
log_archive_dest_state_2 2 ENABLE
log_archive_dest_state_20 2 enable
log_archive_dest_state_21 2 enable
log_archive_dest_state_22 2 enable
log_archive_dest_state_23 2 enable
log_archive_dest_state_24 2 enable
log_archive_dest_state_25 2 enable
log_archive_dest_state_26 2 enable
log_archive_dest_state_27 2 enable
log_archive_dest_state_28 2 enable
log_archive_dest_state_29 2 enable
log_archive_dest_state_3 2 enable
log_archive_dest_state_30 2 enable
log_archive_dest_state_31 2 enable
log_archive_dest_state_4 2 enable
log_archive_dest_state_5 2 enable
log_archive_dest_state_6 2 enable
log_archive_dest_state_7 2 enable
log_archive_dest_state_8 2 enable
log_archive_dest_state_9 2 enable
log_archive_duplex_dest 2
log_archive_format 2 %t_%s_%r.dbf
log_archive_local_first 1 TRUE
log_archive_max_processes 3 4
log_archive_min_succeed_dest 3 1
log_archive_start 1 FALSE
log_archive_trace 3 0
log_buffer 3 20946944
log_checkpoint_interval 3 0
log_checkpoint_timeout 3 1800
log_checkpoints_to_alert 1 FALSE
log_file_name_convert 2 +ORADB/HRDRD, +ORADB/HRPRD, +ORAFRA/HRDRD, +OR
A_FRA/HRPRD
max_dispatchers 3
max_dump_file_size 2 unlimited
max_enabled_roles 3 150
max_shared_servers 3
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
memory_max_target 6 17179869184
memory_target 6 17179869184
nls_calendar 2
nls_comp 2 BINARY
nls_currency 2
nls_date_format 2
nls_date_language 2
nls_dual_currency 2
nls_iso_currency 2
nls_language 2 AMERICAN
nls_length_semantics 2 BYTE
nls_nchar_conv_excp 2 FALSE
nls_numeric_characters 2
nls_sort 2
nls_territory 2 AMERICA
nls_time_format 2
nls_time_tz_format 2
nls_timestamp_format 2
nls_timestamp_tz_format 2
object_cache_max_size_percent 3 10
object_cache_optimal_size 3 102400
olap_page_pool_size 6 0
open_cursors 3 300
open_links 3 4
open_links_per_instance 3 4
optimizer_capture_sql_plan_baseline 1 FALSE
s
optimizer_dynamic_sampling 3 2
optimizer_features_enable 2 11.2.0.3
optimizer_index_caching 3 0
optimizer_index_cost_adj 3 100
optimizer_mode 2 ALL_ROWS
optimizer_secure_view_merging 1 TRUE
optimizer_use_invisible_indexes 1 FALSE
optimizer_use_pending_statistics 1 FALSE
optimizer_use_sql_plan_baselines 1 TRUE
os_authent_prefix 2 ops$
os_roles 1 FALSE
parallel_adaptive_multi_user 1 TRUE
parallel_automatic_tuning 1 FALSE
parallel_degree_limit 2 CPU
parallel_degree_policy 2 MANUAL
parallel_execution_message_size 3 16384
parallel_force_local 1 FALSE
parallel_instance_group 2
parallel_io_cap_enabled 1 FALSE
parallel_max_servers 3 1185
parallel_min_percent 3 0
parallel_min_servers 3 0
parallel_min_time_threshold 2 AUTO
parallel_server 1 TRUE
parallel_server_instances 3 2
parallel_servers_target 3 512
parallel_threads_per_cpu 3 2
permit_92_wrap_format 1 TRUE
pga_aggregate_target 6 0
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
plscope_settings 2 IDENTIFIERS:NONE
plsql_ccflags 2
plsql_code_type 2 INTERPRETED
plsql_debug 1 FALSE
plsql_optimize_level 3 2
plsql_v2_compatibility 1 FALSE
plsql_warnings 2 DISABLE:ALL
pre_page_sga 1 FALSE
processes 3 1200
processor_group_name 2
query_rewrite_enabled 2 TRUE
query_rewrite_integrity 2 enforced
rdbms_server_dn 2
read_only_open_delayed 1 FALSE
recovery_parallelism 3 0
recyclebin 2 on
redo_transport_user 2
remote_dependencies_mode 2 TIMESTAMP
remote_listener 2 hrmsdcdb-scan:1525
remote_login_passwordfile 2 EXCLUSIVE
remote_os_authent 1 FALSE
remote_os_roles 1 FALSE
replication_dependency_tracking 1 TRUE
resource_limit 1 FALSE
resource_manager_cpu_allocation 3 32
resource_manager_plan 2
result_cache_max_result 3 5
result_cache_max_size 6 42958848
result_cache_mode 2 MANUAL
result_cache_remote_expiration 3 0
resumable_timeout 3 0
rollback_segments 2
sec_case_sensitive_logon 1 TRUE
sec_max_failed_login_attempts 3 10
sec_protocol_error_further_action 2 CONTINUE
sec_protocol_error_trace_action 2 TRACE
sec_return_server_release_banner 1 FALSE
serial_reuse 2 disable
service_names 2 HRPRD
session_cached_cursors 3 50
session_max_open_files 3 10
sessions 3 1824
sga_max_size 6 17179869184
sga_target 6 0
shadow_core_dump 2 partial
shared_memory_address 3 0
shared_pool_reserved_size 6 273468620
shared_pool_size 6 0
shared_server_sessions 3
shared_servers 3 1
skip_unusable_indexes 1 TRUE
smtp_out_server 2
sort_area_retained_size 3 0
sort_area_size 3 65536
spfile 2 +ORADB/hrprd/spfilehrprd.ora
sql92_security 1 FALSE
sql_trace 1 FALSE
Press Return to Continue
NAME TYPE VALUE
----------------------------------- ---------- --------------------------------------------------
sqltune_category 2 DEFAULT
standby_archive_dest 2 ?/dbs/arch
standby_file_management 2 AUTO
star_transformation_enabled 2 FALSE
statistics_level 2 TYPICAL
streams_pool_size 6 0
tape_asynch_io 1 TRUE
thread 3 1
timed_os_statistics 3 0
timed_statistics 1 TRUE
trace_enabled 1 TRUE
tracefile_identifier 2
transactions 3 2006
transactions_per_rollback_segment 3 5
undo_management 2 AUTO
undo_retention 3 900
undo_tablespace 2 PSUNDOTS1
use_indirect_data_buffers 1 FALSE
use_large_pages 2 TRUE
user_dump_dest 2 /u01/app/oracle/diag/rdbms/hrprd/HRPRD1/trace
utl_file_dir 2
workarea_size_policy 2 AUTO
xml_db_events 2 enable
347 rows selected.
SQL>
No comments:
Post a Comment