oracle@rac01:/oracle/product/db/11.2.0.3/dbs>cat initrac1.ora
rac2.__db_cache_size=10066329600
rac1.__db_cache_size=4160749568
rac1.__java_pool_size=939524096
rac2.__java_pool_size=939524096
rac1.__large_pool_size=134217728
rac2.__large_pool_size=134217728
rac2.__oracle_base='/oracle/product'#ORACLE_BASE set from environment
rac1.__oracle_base='/oracle/product'#ORACLE_BASE set from environment
rac2.__pga_aggregate_target=22548578304
rac1.__pga_aggregate_target=31541166080
rac2.__sga_target=31138512896
rac1.__sga_target=23756537856
rac1.__shared_io_pool_size=0
rac2.__shared_io_pool_size=0
rac2.__shared_pool_size=16240345088
rac1.__shared_pool_size=13421772800
rac2.__streams_pool_size=268435456
rac1.__streams_pool_size=268435456
*._optimizer_use_feedback=FALSE
*.archive_lag_target=600
*.audit_file_dest='/oracle/product/admin/rac/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/rac/controlfile/current.266.771064763','+FRADG/rac/controlfile/current.256.771064763'
*.db_block_size=8192
*.db_create_file_dest='+DATA/'
*.db_domain=''
*.db_flashback_retention_target=1440
*.db_keep_cache_size=3221225472
*.db_name='rac'
*.db_recovery_file_dest='+FRADG'
*.db_recovery_file_dest_size=429496729600
*.ddl_lock_timeout=0
*.diagnostic_dest='/oracle/product'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racXDB)'
*.fal_client='rac1,rac2'
*.fal_server='racdg'
rac1.instance_number=1
rac2.instance_number=2
*.log_archive_config='dg_config=(rac,racdg)'
*.log_archive_dest_1='location=+DATA valid_for=(ALL_LOGFILES,ALL_ROLES)'
*.log_archive_dest_2='service=racdg async valid_for=(online_logfiles,primary_role) db_unique_name=racdg delay=120'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_max_target=53687091200
*.memory_target=53687091200
*.open_cursors=300
*.open_links=8
*.open_links_per_instance=8
*.optimizer_index_caching=50
*.optimizer_index_cost_adj=8
*.plsql_code_type='INTERPRETED'
*.plsql_optimize_level=3
*.processes=1000
*.remote_listener='rac-scan:1521'
*.remote_login_passwordfile='exclusive'
*.result_cache_max_size=314572800
*.sec_case_sensitive_logon=TRUE
*.sessions=1105
*.standby_file_management='AUTO'
rac2.thread=2
rac1.thread=1
*.undo_retention=3600
rac1.undo_tablespace='UNDOTBS1'
rac2.undo_tablespace='UNDOTBS2'
*.utl_file_dir='/home/oracle'
oracle@rac01:/oracle/product/db/11.2.0.3/dbs>
NAME | TYPE | VALUE | DISPLAY_VALUE |
open_links_per_instance | 3 | 8 | 8 |
open_links | 3 | 8 | 8 |
utl_file_dir | 2 | /home/oracle | /home/oracle |
log_archive_dest_2 | 2 | service=racpdg async valid_for=(online_logfiles,primary_role) db_unique_name=racpdg delay=120 | service=racpdg async valid_for=(online_logfiles,primary_role) db_unique_name=racpdg delay=120 |
log_archive_format | 2 | %t_%s_%r.dbf | %t_%s_%r.dbf |
dispatchers | 2 | (PROTOCOL=TCP) (SERVICE=racpXDB) | (PROTOCOL=TCP) (SERVICE=racpXDB) |
spfile | 2 | =+DATA/racp/spfileracp.ora' | =+DATA/racp/spfileracp.ora' |
optimizer_index_caching | 3 | 50 | 50 |
archive_lag_target | 3 | 600 | 600 |
log_archive_dest_state_2 | 2 | ENABLE | ENABLE |
_optimizer_use_feedback | 1 | FALSE | FALSE |
log_archive_config | 2 | dg_config=(racp,racpdg) | dg_config=(racp,racpdg) |
plsql_optimize_level | 3 | 3 | 3 |
remote_login_passwordfile | 2 | EXCLUSIVE | EXCLUSIVE |
db_keep_cache_size | 6 | 3221225472 | 3G |
db_domain | 2 | ||
plsql_code_type | 2 | INTERPRETED | INTERPRETED |
compatible | 2 | 11.2.0.0.0 | 11.2.0.0.0 |
fal_server | 2 | racpdg | racpdg |
log_archive_dest_1 | 2 | location=+DATA valid_for=(ALL_LOGFILES,ALL_ROLES) | location=+DATA valid_for=(ALL_LOGFILES,ALL_ROLES) |
ddl_lock_timeout | 3 | 0 | 0 |
sec_case_sensitive_logon | 1 | TRUE | TRUE |
fal_client | 2 | racp1,racp2 | racp1,racp2 |
audit_file_dest | 2 | /oracle/product/admin/racp/adump | /oracle/product/admin/racp/adump |
thread | 3 | 1 | 1 |
db_block_size | 3 | 8192 | 8192 |
open_cursors | 3 | 300 | 300 |
db_recovery_file_dest_size | 6 | 4.29497E+11 | 400G |
standby_file_management | 2 | AUTO | AUTO |
db_name | 2 | racp | racp |
sessions | 3 | 1536 | 1536 |
processes | 3 | 1000 | 1000 |
db_flashback_retention_target | 3 | 1440 | 1440 |
diagnostic_dest | 2 | /oracle/product | /oracle/product |
result_cache_max_size | 6 | 314572800 | 300M |
remote_listener | 2 | racp-scan:1521 | racp-scan:1521 |
instance_number | 3 | 1 | 1 |
db_create_file_dest | 2 | +DATA/ | +DATA/ |
memory_max_target | 6 | 53687091200 | 50G |
cluster_database | 1 | TRUE | TRUE |
memory_target | 6 | 53687091200 | 50G |
control_files | 2 | +DATA/racp/controlfile/current.266.771064763, +FRADG/racp/controlfile/current.256.771064763 | +DATA/racp/controlfile/current.266.771064763, +FRADG/racp/controlfile/current.256.771064763 |
audit_trail | 2 | DB | DB |
db_recovery_file_dest | 2 | #NAME? | #NAME? |
undo_tablespace | 2 | UNDOTBS1 | UNDOTBS1 |
optimizer_index_cost_adj | 3 | 8 | 8 |
undo_retention | 3 | 3600 | 3600 |
smtp_out_server | 2 | ||
cursor_space_for_time | 1 | FALSE | FALSE |
listener_networks | 2 | ||
remote_dependencies_mode | 2 | TIMESTAMP | TIMESTAMP |
session_cached_cursors | 3 | 50 | 50 |
plsql_v2_compatibility | 1 | FALSE | FALSE |
cursor_sharing | 2 | EXACT | EXACT |
bitmap_merge_area_size | 3 | 1048576 | 1048576 |
create_bitmap_area_size | 3 | 8388608 | 8388608 |
result_cache_mode | 2 | MANUAL | MANUAL |
parallel_instance_group | 2 | ||
parallel_max_servers | 3 | 985 | 985 |
parallel_min_servers | 3 | 0 | 0 |
parallel_min_percent | 3 | 0 | 0 |
plsql_ccflags | 2 | ||
plsql_debug | 1 | FALSE | FALSE |
plsql_warnings | 2 | DISABLE:ALL | DISABLE:ALL |
plscope_settings | 2 | IDENTIFIERS:NONE | IDENTIFIERS:NONE |
job_queue_processes | 3 | 1000 | 1000 |
java_jit_enabled | 1 | TRUE | TRUE |
permit_92_wrap_format | 1 | TRUE | TRUE |
create_stored_outlines | 2 | ||
serial_reuse | 2 | disable | disable |
recyclebin | 2 | on | on |
db_securefile | 2 | PERMITTED | PERMITTED |
ldap_directory_access | 2 | NONE | NONE |
rdbms_server_dn | 2 | ||
max_enabled_roles | 3 | 150 | 150 |
ldap_directory_sysauth | 2 | no | no |
os_roles | 1 | FALSE | FALSE |
transactions | 3 | 1689 | 1689 |
transactions_per_rollback_segment | 3 | 5 | 5 |
dml_locks | 3 | 6756 | 6756 |
replication_dependency_tracking | 1 | TRUE | TRUE |
rollback_segments | 2 | ||
resumable_timeout | 3 | 0 | 0 |
db_block_checking | 2 | FALSE | FALSE |
undo_management | 2 | AUTO | AUTO |
fast_start_parallel_rollback | 2 | LOW | LOW |
service_names | 2 | racp | racp |
shared_servers | 3 | 1 | 1 |
global_txn_processes | 3 | 1 | 1 |
instance_name | 2 | racp1 | racp1 |
max_shared_servers | 3 | ||
shared_server_sessions | 3 | ||
local_listener | 2 | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.11.11)(PORT=1521)))) | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.11.11)(PORT=1521)))) |
max_dispatchers | 3 | ||
circuits | 3 | ||
O7_DICTIONARY_ACCESSIBILITY | 1 | FALSE | FALSE |
license_max_users | 3 | 0 | 0 |
remote_os_authent | 1 | FALSE | FALSE |
remote_os_roles | 1 | FALSE | FALSE |
audit_sys_operations | 1 | FALSE | FALSE |
distributed_lock_timeout | 3 | 60 | 60 |
commit_point_strength | 3 | 1 | 1 |
global_context_pool_size | 2 | ||
global_names | 1 | FALSE | FALSE |
parallel_execution_message_size | 3 | 16384 | 16384 |
optimizer_use_invisible_indexes | 1 | FALSE | FALSE |
dst_upgrade_insert_conv | 1 | TRUE | TRUE |
parallel_force_local | 1 | FALSE | FALSE |
parallel_min_time_threshold | 2 | AUTO | AUTO |
parallel_degree_limit | 2 | CPU | CPU |
sec_max_failed_login_attempts | 3 | 10 | 10 |
sec_return_server_release_banner | 1 | FALSE | FALSE |
sec_protocol_error_further_action | 2 | CONTINUE | CONTINUE |
parallel_servers_target | 3 | 768 | 768 |
sec_protocol_error_trace_action | 2 | TRACE | TRACE |
cursor_bind_capture_destination | 2 | memory+disk | memory+disk |
skip_unusable_indexes | 1 | TRUE | TRUE |
statistics_level | 2 | TYPICAL | TYPICAL |
workarea_size_policy | 2 | AUTO | AUTO |
optimizer_dynamic_sampling | 3 | 2 | 2 |
optimizer_capture_sql_plan_baselines | 1 | FALSE | FALSE |
optimizer_use_sql_plan_baselines | 1 | TRUE | TRUE |
optimizer_use_pending_statistics | 1 | FALSE | FALSE |
optimizer_secure_view_merging | 1 | TRUE | TRUE |
deferred_segment_creation | 1 | TRUE | TRUE |
asm_power_limit | 3 | 1 | 1 |
control_management_pack_access | 2 | DIAGNOSTIC+TUNING | DIAGNOSTIC+TUNING |
asm_diskgroups | 2 | ||
asm_diskstring | 2 | ||
asm_preferred_read_failure_groups | 2 | ||
max_dump_file_size | 2 | unlimited | unlimited |
trace_enabled | 1 | TRUE | TRUE |
tracefile_identifier | 2 | ||
awr_snapshot_time_offset | 3 | 0 | 0 |
sqltune_category | 2 | DEFAULT | DEFAULT |
aq_tm_processes | 3 | 1 | 1 |
hs_autoregister | 1 | TRUE | TRUE |
client_result_cache_lag | 6 | 3000 | 3000 |
enable_ddl_logging | 1 | FALSE | FALSE |
client_result_cache_size | 6 | 0 | 0 |
dg_broker_config_file2 | 2 | /oracle/product/db/11.2.0.3/dbs/dr2racp.dat | /oracle/product/db/11.2.0.3/dbs/dr2racp.dat |
olap_page_pool_size | 6 | 0 | 0 |
dg_broker_config_file1 | 2 | /oracle/product/db/11.2.0.3/dbs/dr1racp.dat | /oracle/product/db/11.2.0.3/dbs/dr1racp.dat |
xml_db_events | 2 | enable | enable |
dg_broker_start | 1 | FALSE | FALSE |
pga_aggregate_target | 6 | 0 | 0 |
commit_write | 2 | ||
commit_wait | 2 | ||
session_max_open_files | 3 | 10 | 10 |
object_cache_optimal_size | 3 | 102400 | 102400 |
object_cache_max_size_percent | 3 | 10 | 10 |
sort_area_size | 3 | 65536 | 65536 |
sort_area_retained_size | 3 | 0 | 0 |
fixed_date | 2 | ||
commit_logging | 2 | ||
optimizer_features_enable | 2 | 11.2.0.3 | 11.2.0.3 |
shadow_core_dump | 2 | partial | partial |
background_core_dump | 2 | partial | partial |
result_cache_remote_expiration | 3 | 0 | 0 |
hash_area_size | 3 | 131072 | 131072 |
result_cache_max_result | 3 | 5 | 5 |
use_sigio | 1 | TRUE | TRUE |
audit_syslog_level | 2 | ||
core_dump_dest | 2 | /oracle/product/diag/rdbms/racp/racp1/cdump | /oracle/product/diag/rdbms/racp/racp1/cdump |
background_dump_dest | 2 | /oracle/product/diag/rdbms/racp/racp1/trace | /oracle/product/diag/rdbms/racp/racp1/trace |
user_dump_dest | 2 | /oracle/product/diag/rdbms/racp/racp1/trace | /oracle/product/diag/rdbms/racp/racp1/trace |
parallel_degree_policy | 2 | MANUAL | MANUAL |
parallel_adaptive_multi_user | 1 | TRUE | TRUE |
star_transformation_enabled | 2 | FALSE | FALSE |
sql92_security | 1 | FALSE | FALSE |
blank_trimming | 1 | FALSE | FALSE |
query_rewrite_enabled | 2 | TRUE | TRUE |
query_rewrite_integrity | 2 | enforced | enforced |
parallel_io_cap_enabled | 1 | FALSE | FALSE |
parallel_threads_per_cpu | 3 | 2 | 2 |
parallel_automatic_tuning | 1 | FALSE | FALSE |
cell_offload_compaction | 2 | ADAPTIVE | ADAPTIVE |
cell_offload_plan_display | 2 | AUTO | AUTO |
cell_offload_parameters | 2 | ||
cell_offload_processing | 1 | TRUE | TRUE |
cell_offload_decryption | 1 | TRUE | TRUE |
os_authent_prefix | 2 | ops$ | ops$ |
optimizer_mode | 2 | ALL_ROWS | ALL_ROWS |
sql_trace | 1 | FALSE | FALSE |
db_unique_name | 2 | racp | racp |
ifile | 4 | ||
active_instance_count | 3 | ||
sga_target | 6 | 0 | 0 |
gcs_server_processes | 3 | 3 | 3 |
cluster_interconnects | 2 | ||
file_mapping | 1 | FALSE | FALSE |
db_block_buffers | 3 | 0 | 0 |
db_block_checksum | 2 | TYPICAL | TYPICAL |
control_file_record_keep_time | 3 | 7 | 7 |
db_file_name_convert | 2 | ||
log_file_name_convert | 2 | ||
clonedb | 1 | FALSE | FALSE |
disk_asynch_io | 1 | TRUE | TRUE |
filesystemio_options | 2 | asynch | asynch |
nls_nchar_conv_excp | 2 | FALSE | FALSE |
fileio_network_adapters | 2 | ||
resource_manager_cpu_allocation | 3 | 48 | 48 |
resource_manager_plan | 2 | ||
backup_tape_io_slaves | 1 | FALSE | FALSE |
tape_asynch_io | 1 | TRUE | TRUE |
dbwr_io_slaves | 3 | 0 | 0 |
db_cache_advice | 2 | ON | ON |
log_archive_dest_3 | 2 | ||
db_flash_cache_size | 6 | 0 | 0 |
buffer_pool_recycle | 2 | ||
db_flash_cache_file | 2 | ||
log_archive_dest_7 | 2 | ||
log_archive_dest_8 | 2 | ||
log_archive_dest_6 | 2 | ||
log_archive_dest_4 | 2 | ||
log_archive_dest_5 | 2 | ||
db_4k_cache_size | 6 | 0 | 0 |
db_8k_cache_size | 6 | 0 | 0 |
db_2k_cache_size | 6 | 0 | 0 |
db_ultra_safe | 2 | OFF | OFF |
db_cache_size | 6 | 0 | 0 |
db_writer_processes | 3 | 6 | 6 |
buffer_pool_keep | 2 | ||
db_recycle_cache_size | 6 | 0 | 0 |
db_16k_cache_size | 6 | 0 | 0 |
db_32k_cache_size | 6 | 0 | 0 |
nls_length_semantics | 2 | BYTE | BYTE |
hi_shared_memory_address | 3 | 0 | 0 |
use_indirect_data_buffers | 1 | FALSE | FALSE |
shared_memory_address | 3 | 0 | 0 |
use_large_pages | 2 | TRUE | TRUE |
pre_page_sga | 1 | FALSE | FALSE |
large_pool_size | 6 | 0 | 0 |
java_pool_size | 6 | 0 | 0 |
shared_pool_size | 6 | 0 | 0 |
lock_sga | 1 | FALSE | FALSE |
processor_group_name | 2 | ||
resource_limit | 1 | FALSE | FALSE |
license_max_sessions | 3 | 0 | 0 |
timed_os_statistics | 3 | 0 | 0 |
lock_name_space | 2 | ||
timed_statistics | 1 | TRUE | TRUE |
event | 2 | ||
sga_max_size | 6 | 53687091200 | 50G |
instance_groups | 2 | ||
license_sessions_warning | 3 | 0 | 0 |
cpu_count | 3 | 48 | 48 |
nls_calendar | 2 | GREGORIAN | GREGORIAN |
nls_time_format | 2 | HH.MI.SSXFF AM | HH.MI.SSXFF AM |
nls_iso_currency | 2 | CHINA | CHINA |
nls_currency | 2 | ¥ | ¥ |
nls_numeric_characters | 2 | ., | ., |
nls_dual_currency | 2 | ¥ | ¥ |
nls_comp | 2 | BINARY | BINARY |
nls_timestamp_tz_format | 2 | DD-MON-RR HH.MI.SSXFF AM TZR | DD-MON-RR HH.MI.SSXFF AM TZR |
nls_timestamp_format | 2 | DD-MON-RR HH.MI.SSXFF AM | DD-MON-RR HH.MI.SSXFF AM |
nls_time_tz_format | 2 | HH.MI.SSXFF AM TZR | HH.MI.SSXFF AM TZR |
java_max_sessionspace_size | 3 | 0 | 0 |
instance_type | 2 | RDBMS | RDBMS |
java_soft_sessionspace_limit | 3 | 0 | 0 |
streams_pool_size | 6 | 0 | 0 |
shared_pool_reserved_size | 6 | 691221299 | 691221299 |
nls_date_language | 2 | SIMPLIFIED CHINESE | SIMPLIFIED CHINESE |
nls_date_format | 2 | DD-MON-RR | DD-MON-RR |
nls_sort | 2 | BINARY | BINARY |
nls_language | 2 | SIMPLIFIED CHINESE | SIMPLIFIED CHINESE |
nls_territory | 2 | CHINA | CHINA |
log_archive_dest_9 | 2 | ||
log_archive_duplex_dest | 2 | ||
log_archive_min_succeed_dest | 3 | 1 | 1 |
log_archive_dest | 2 | ||
log_archive_dest_state_31 | 2 | enable | enable |
log_archive_start | 1 | FALSE | FALSE |
redo_transport_user | 2 | ||
log_archive_max_processes | 3 | 4 | 4 |
log_archive_local_first | 1 | TRUE | TRUE |
standby_archive_dest | 2 | ?/dbs/arch | ?/dbs/arch |
log_archive_trace | 3 | 0 | 0 |
log_archive_dest_state_24 | 2 | enable | enable |
log_archive_dest_state_25 | 2 | enable | enable |
log_archive_dest_state_23 | 2 | enable | enable |
log_archive_dest_state_21 | 2 | enable | enable |
log_archive_dest_state_22 | 2 | enable | enable |
log_archive_dest_state_29 | 2 | enable | enable |
log_archive_dest_state_30 | 2 | enable | enable |
log_archive_dest_state_28 | 2 | enable | enable |
log_archive_dest_state_26 | 2 | enable | enable |
log_archive_dest_state_27 | 2 | enable | enable |
db_create_online_log_dest_5 | 2 | ||
db_unrecoverable_scn_tracking | 1 | TRUE | TRUE |
db_create_online_log_dest_4 | 2 | ||
db_create_online_log_dest_2 | 2 | ||
db_create_online_log_dest_3 | 2 | ||
db_lost_write_protect | 2 | NONE | NONE |
recovery_parallelism | 3 | 0 | 0 |
log_checkpoints_to_alert | 1 | FALSE | FALSE |
fast_start_io_target | 3 | 0 | 0 |
fast_start_mttr_target | 3 | 0 | 0 |
db_files | 3 | 200 | 200 |
db_file_multiblock_read_count | 3 | 128 | 128 |
log_checkpoint_timeout | 3 | 1800 | 1800 |
log_buffer | 3 | 25608192 | 25608192 |
log_checkpoint_interval | 3 | 0 | 0 |
cluster_database_instances | 3 | 2 | 2 |
db_create_online_log_dest_1 | 2 | ||
parallel_server_instances | 3 | 2 | 2 |
read_only_open_delayed | 1 | FALSE | FALSE |
parallel_server | 1 | TRUE | TRUE |
log_archive_dest_state_20 | 2 | enable | enable |
log_archive_dest_23 | 2 | ||
log_archive_dest_24 | 2 | ||
log_archive_dest_22 | 2 | ||
log_archive_dest_20 | 2 | ||
log_archive_dest_21 | 2 | ||
log_archive_dest_28 | 2 | ||
log_archive_dest_29 | 2 | ||
log_archive_dest_27 | 2 | ||
log_archive_dest_25 | 2 | ||
log_archive_dest_26 | 2 | ||
log_archive_dest_13 | 2 | ||
log_archive_dest_14 | 2 | ||
log_archive_dest_12 | 2 | ||
log_archive_dest_10 | 2 | ||
log_archive_dest_11 | 2 | ||
log_archive_dest_18 | 2 | ||
log_archive_dest_19 | 2 | ||
log_archive_dest_17 | 2 | ||
log_archive_dest_15 | 2 | ||
log_archive_dest_16 | 2 | ||
log_archive_dest_state_13 | 2 | enable | enable |
log_archive_dest_state_14 | 2 | enable | enable |
log_archive_dest_state_12 | 2 | enable | enable |
log_archive_dest_state_10 | 2 | enable | enable |
log_archive_dest_state_11 | 2 | enable | enable |
log_archive_dest_state_18 | 2 | enable | enable |
log_archive_dest_state_19 | 2 | enable | enable |
log_archive_dest_state_17 | 2 | enable | enable |
log_archive_dest_state_15 | 2 | enable | enable |
log_archive_dest_state_16 | 2 | enable | enable |
log_archive_dest_state_3 | 2 | enable | enable |
log_archive_dest_state_4 | 2 | enable | enable |
log_archive_dest_state_1 | 2 | enable | enable |
log_archive_dest_30 | 2 | ||
log_archive_dest_31 | 2 | ||
log_archive_dest_state_8 | 2 | enable | enable |
log_archive_dest_state_9 | 2 | enable | enable |
log_archive_dest_state_7 | 2 | enable | enable |
log_archive_dest_state_5 | 2 | enable | enable |
log_archive_dest_state_6 | 2 | enable | enable |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11990065/viewspace-753370/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11990065/viewspace-753370/