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博客

RAC pfile

最新文章