PRODCDB1.__data_transfer_cache_size=0
PRODCDB2.__data_transfer_cache_size=0
PRODCDB1.__db_cache_size=472983273472
PRODCDB2.__db_cache_size=473520144384
PRODCDB1.__inmemory_ext_roarea=0
PRODCDB2.__inmemory_ext_roarea=0
PRODCDB1.__inmemory_ext_rwarea=0
PRODCDB2.__inmemory_ext_rwarea=0
PRODCDB1.__java_pool_size=4294967296
PRODCDB2.__java_pool_size=3758096384
PRODCDB1.__large_pool_size=1073741824
PRODCDB2.__large_pool_size=536870912
PRODCDB1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
PRODCDB2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
PRODCDB1.__pga_aggregate_target=107374182400
PRODCDB2.__pga_aggregate_target=107374182400
PRODCDB1.__sga_target=549755813888
PRODCDB2.__sga_target=549755813888
PRODCDB1.__shared_io_pool_size=536870912
PRODCDB2.__shared_io_pool_size=536870912
PRODCDB1.__shared_pool_size=69256347648
PRODCDB2.__shared_pool_size=69793218560
PRODCDB1.__streams_pool_size=1073741824
PRODCDB2.__streams_pool_size=1073741824
PRODCDB1.__unified_pga_pool_size=0
PRODCDB2.__unified_pga_pool_size=0
*._b_tree_bitmap_plans=FALSE#MP
*._disable_actualization_for_grant=TRUE#MP
*._fast_full_scan_enabled=FALSE#MP
*._like_with_bind_as_equality=TRUE#MP
*._optimizer_autostats_job=FALSE#MP Turn off automatic statistics.
*._optimizer_cbqt_or_expansion='OFF'#Doc ID2747498.1
*._optimizer_gather_stats_on_conventional_dml=FALSE#MP
*._optimizer_use_stats_on_conventional_dml=FALSE#MP
*._pdb_name_case_sensitive=TRUE#MP
*._px_cdb_view_enabled=FALSE#Doc ID 2662860.1
*._sort_elimination_cost_ratio=5#MP
*._system_trig_enabled=TRUE#MP
*._trace_files_public=FALSE#prod11g
*._use_realfree_heap=TRUE#prod11g
*.aq_tm_processes=10#prod11g
*.audit_file_dest='/u01/app/oracle/admin/PRODCDB/adump'
*.audit_trail='none'#prod11g
*.cluster_database=TRUE#MP
*.compatible='19.0.0'#MP
*.CONTAINER_DATA='CURRENT_DICTIONARY'#Doc ID2900744.1
*.control_files='+DATA/PRODCDB/CONTROLFILE/controlfile_prodcdb01.ctl','+ARCH/PRODCDB/CONTROLFILE/controlfile_prodcdb02.ctl'
*.cursor_sharing='EXACT'#MP
*.db_block_checking='FALSE'#prod11g
*.db_block_checksum='TRUE'#prod11g
*.db_block_size=8192#MP
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+REDOMEM1'
*.db_create_online_log_dest_2='+REDOMEM2'
*.db_files=5120#prod11g
*.db_flashback_retention_target=2880
*.db_name='PRODCDB'
*.db_recovery_file_dest='+ARCH'
*.db_recovery_file_dest_size=1024G
*.diagnostic_dest='/u01/app/oracle'#prod11g
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRODCDBXDB)'
*.dml_locks=10000# Database locks. #prod11g
*.enable_goldengate_replication=TRUE#prod11g
*.enable_pluggable_database=true
*.event='10946 trace name context forever, level 8454144'#MP
PRODCDB1.instance_number=1
PRODCDB2.instance_number=2
*.job_queue_processes=16#prod11g
PRODCDB1.local_listener='PRODCDB1_LOCAL' #ip
PRODCDB2.local_listener='PRODCDB2_LOCAL' #ip
*.LOG_ARCHIVE_DEST_1='LOCATION=+ARCH'#prod11g
*.log_archive_format='%t_%s_%r.dbf'#Doc ID 396009.1
*.log_buffer=10485760#Doc ID 396009.1
*.log_checkpoint_interval=100000#Doc ID 396009.1
*.log_checkpoint_timeout=1200#Doc ID 396009.1
*.log_checkpoints_to_alert=TRUE#Doc ID 396009.1
*.max_dump_file_size='20480'#Limit default trace file size to 20 MB.
*.nls_comp='BINARY'#MP
*.nls_date_format='DD-MON-RR'#MP
*.nls_language='AMERICAN'#11g
*.nls_length_semantics='BYTE'#MP
*.nls_numeric_characters='.,'#prod11g
*.nls_sort='BINARY'#MP
*.nls_territory='AMERICA'#prod11g
*.open_cursors=6000#prod11g
*.optimizer_adaptive_plans=TRUE#MP
*.optimizer_adaptive_statistics=FALSE#MP
*.optimizer_real_time_statistics=FALSE#MP
*.optimizer_secure_view_merging=FALSE#MP
*.parallel_degree_policy='MANUAL'#MP
*.parallel_force_local=TRUE#MP
*.parallel_max_servers=128# Max. value should be 2 x no. of CPUs.
*.parallel_min_servers=0
*.pga_aggregate_limit=0#MP
*.pga_aggregate_target=100G
*.processes=8000
*.recyclebin='off'#MP
*.remote_listener='PROD_REMOTE' #ip
*.remote_login_passwordfile='exclusive'
*.result_cache_max_size=600M#Doc ID 396009.1
*.sec_case_sensitive_logon=FALSE
*.service_names='PRODCDB'
*.session_cached_cursors=5000
*.sessions=16016
*.sga_max_size=512G
*.sga_target=512G
*.shared_pool_reserved_size=5G
*.shared_pool_size=50G
*.standby_file_management='AUTO'
*.target_pdbs=1
*.temp_undo_enabled=FALSE
PRODCDB2.thread=2
PRODCDB1.thread=1
*.undo_management='AUTO'#MP
PRODCDB2.undo_tablespace='UNDOTBS2'
PRODCDB1.undo_tablespace='UNDOTBS1'
*.workarea_size_policy='AUTO'#MP
prod_pfile_20230131
未经允许不得转载:徐万新之路 » prod_pfile_20230131
最新评论
这个牛
放下欲望,男人从来不醉,充分且必要
勇气、责任、自信、创新,为天下先!
软件即数据,软件即服务,软件即管理,软件就是对人类各种社会活动的仿真和记录。软件很重要,但软件不可能凌驾于业务之上,尤其不可能高人一等。