{"id":3260,"date":"2018-02-04T10:24:27","date_gmt":"2018-02-04T01:24:27","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3260"},"modified":"2018-02-04T10:24:27","modified_gmt":"2018-02-04T01:24:27","slug":"tip-%ea%b8%88%ec%9c%b5%ea%b6%8c-%eb%8c%80%ec%9a%a9%eb%9f%89-oracle-db-%ec%9d%98-init-ora-%ea%b4%80%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3260","title":{"rendered":"[TIP] \uae08\uc735\uad8c \ub300\uc6a9\ub7c9 Oracle DB \uc758 init.ora \uad00\ub9ac"},"content":{"rendered":"

Oracle 3-node RAC \uc5d0\uc11c\u00a0 Oracle 10g R2 \ubc84\uc804\u00a0 DB\uc758 \ud30c\ub77c\ubbf8\ud130 init.ora \uad00\ub9ac \uc608\uc2dc ….<\/p>\n

\uae08\uc735\uad8c \uc774\ub098 \ud2b8\ub798\ud53d\uc774 \uad49\uc7a5\ud788 \ub9ce\uc740 \ud14c\ub77c\uae09 \uc0ac\uc774\ud2b8\ub294 PFILE \ud615\ud0dc \ub85c init.ora \ud30c\uc77c\uc744 \ud0c0\uc774\ud2b8\ud558\uac8c \uc9c1\uc811 DBA \uac00 \uad00\ub9ac \ud569\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

##############################################################################\r\n# haisins oracle 10g Release 2 RAC 3 node\r\n##############################################################################\r\n \r\n###########################################\r\n# Archive\r\n###########################################\r\n*.log_archive_dest_1='LOCATION=\/ora_arch\/ORADB MANDATORY REOPEN=5'        #haisins\r\n*.log_archive_format=arch_ORADB_%r_%t_%s.dbf\r\n*.log_checkpoints_to_alert=TRUE                                         #haisins\r\n*.fast_start_mttr_target=300  ## 5 min                                  #haisins\r\n### *.fast_start_mttr_target=1800           ### for MIG\r\n\r\n*.recovery_parallelism=32               ###  DISK\r\n*.fast_start_parallel_rollback=false    ### Note 464246.1\r\n \r\n###########################################\r\n# Cache and I\/O\r\n###########################################\r\n*.db_block_size=8192\r\n*.db_cache_size=30G                                                     #haisins Total RealMemory 224G (before_db:30640M)\r\n###*.db_cache_size=3G                                                   #haisins Total RealMemory 224G (before_db:30640M)\r\n###*.db_keep_cache_size=2G                                                      #haisins (before_db:2G)\r\n*.db_keep_cache_size=40G                                                        #haisins (before_db:2G)\r\n*.db_file_multiblock_read_count=16\r\n###*.db_file_multiblock_read_count=128\r\n*.db_files=8000                                                         #haisins\r\n\r\n# *._smm_auto_max_io_size=1008            ### default 248  for MIG only\r\n# *._smm_auto_min_io_size=1008            ### default 56   for MIG only\r\n \r\n###########################################\r\n# Cluster Database\r\n###########################################\r\n*.cluster_database_instances=3\r\n*.cluster_database=true\r\n###  *.cluster_database=false\r\n#remote_listener=LISTENERS_ORADB                                          #haisins\r\n\r\nORADB1.instance_groups='ORADB1'\r\nORADB2.instance_groups='ORADB2'\r\nORADB3.instance_groups='ORADB3'\r\n\r\nORADB1.parallel_instance_group='ORADB1'\r\nORADB2.parallel_instance_group='ORADB2'\r\nORADB3.parallel_instance_group='ORADB3'\r\n\r\nORADB1.instance_number=1\r\nORADB2.instance_number=2\r\nORADB3.instance_number=3\r\n\r\nORADB1.thread=1\r\nORADB2.thread=2\r\nORADB3.thread=3\r\n \r\n###########################################\r\n# Cursors and Library Cache\r\n###########################################\r\n*.open_cursors=1500                                                     #haisins 300 -> 1500 (before_db:1500)\r\n*.open_links=16                                                         #haisins 4 -> 16 (before_db:16)\r\n*.session_cached_cursors=200                                            #haisins 20 -> 200 (before_db:100)\r\n \r\n###########################################\r\n# Database Identification\r\n###########################################\r\n*.db_domain=\"\"\r\n*.db_name=ORADB\r\n*.service_names=ORADB                                                     #haisins\r\n \r\n###########################################\r\n# Diagnostics and Statistics\r\n###########################################\r\n*.background_dump_dest=\/ora_trc\/admin\/ORADB\/bdump                         #haisins\r\n*.core_dump_dest=\/ora_trc\/admin\/ORADB\/cdump                               #haisins\r\n*.user_dump_dest=\/ora_trc\/admin\/ORADB\/udump                               #haisins\r\n*.max_dump_file_size=409600                                             #haisins\r\n \r\n###########################################\r\n# File Configuration\r\n###########################################\r\n*.control_files=(\"\/dev\/vx\/rdsk\/MDB09\/ctrl01\", \"\/dev\/vx\/rdsk\/MDB09\/ctrl02\", \"\/dev\/vx\/rdsk\/MDB10\/ctrl03\")\r\n \r\n###########################################\r\n# Job Queues\r\n###########################################\r\n*.job_queue_processes=10\r\n \r\n\r\n###########################################\r\n# Listener\r\n###########################################\r\nORADB1.local_listener=ORADB1_LL\r\nORADB2.local_listener=ORADB2_LL\r\nORADB3.local_listener=ORADB3_LL\r\n### ORADB1.remote_listener=ORADB1_RL\r\n### ORADB2.remote_listener=ORADB2_RL\r\n### ORADB3.remote_listener=ORADB3_RL\r\n\r\n###########################################\r\n# Miscellaneous\r\n###########################################\r\n*.compatible=10.2.0.4.0\r\n\r\n###########################################\r\n# Parallel Executions\r\n###########################################\r\n### *.parallel_max_servers=300             ## CPU * 4 1800MHz*36                #haisins (before_db:300)\r\n*.parallel_max_servers=720             ## CPU * 4 1800MHz*36            #haisins (before_db:300)    ######## Mig only\r\n*.parallel_execution_message_size=8192 ## tuning                        #haisins (default:2152, before_db:8192)\r\n*._PX_use_large_pool=TRUE              ## tuning                        #haisins (before_db:TRUE)\r\n*.parallel_adaptive_multi_user=FALSE   ## manual                        #haisins (Default:TRUE, before_db:FALSE)\r\n\r\n\r\n###########################################\r\n# Optimizer\r\n###########################################\r\n# *.optimizer_mode=all_rows                 ### MIG only\r\n*.optimizer_mode=first_rows_1         ## all_rows\/first_rows_1\/10\/100\/1000 #haisins (Default,before_db:first_row_1)\r\n# *.optimizer_index_caching =80                                         #haisins (Default,before_db:0)\r\n# *.optimizer_index_cost_adj=30                                         #haisins (Default,before_db:100)\r\n*.optimizer_dynamic_sampling=0        ## disable dynamic sampling       #haisins (Default,before_db:0)\r\n*._optim_peek_user_binds=FALSE        ## Disable Bind Peeking           #haisins (Default,before_db:FALSE)\r\n \r\n###########################################\r\n# Pools\r\n###########################################\r\n#*.java_pool_size=250M                                                  #haisins Only PatchSetApply\r\n*.large_pool_size=1G                                                    #haisins (before_db:304M)  1G -> 500M\r\n*.shared_pool_size=8G                                                   #haisins (before_db:3200M) 5G -> 8G\r\n*.shared_pool_reserved_size=800M                                        #haisins (before_db:300M)\r\n*.log_buffer=30486528                                                   #haisins (before_db:30486528)\r\n \r\n###########################################\r\n# Processes and Sessions\r\n###########################################\r\n*.processes=5000\r\n#*.sessions=5505\r\n*.aq_tm_processes=1                                                     #haisins 0 -> 1 (before_db:1)\r\n \r\n###########################################\r\n# Security and Auditing\r\n###########################################\r\n# audit_file_dest=\/oraom\/admin\/ORADB\/adump                                #haisins\r\n*.remote_login_passwordfile=exclusive\r\n \r\n###########################################\r\n# Sort, Hash Joins, Bitmap Indexes\r\n###########################################\r\n*.sort_area_size=1048576                                                #haisins 1M(Default 1M)\r\n*.workarea_size_policy=AUTO                                             #haisins\r\n*.pga_aggregate_target=50G                                              #haisins 20G -> 40G (before_db:40G)\r\n \r\n###########################################\r\n# System Managed Undo and Rollback Segments\r\n###########################################\r\n*.undo_management=AUTO\r\n*.undo_retention=21600       # 1800(0.5H) 7200(2H) 21600(6H)            #haisins\r\n### *._undo_autotune=FALSE   ## use undo_retention (disable autotune)   #haisins\r\n### *.undo_retention=1800                   ### MIG only\r\n \r\nORADB1.undo_tablespace=UNDOTBS1\r\nORADB2.undo_tablespace=UNDOTBS2\r\nORADB3.undo_tablespace=UNDOTBS3\r\n\r\n\r\n###########################################\r\n# Miscellaneous\r\n###########################################\r\n*._trace_files_public=true\r\n# *._transaction_auditing=FALSE           ### MIG only\r\n### *._gby_hash_aggregation_enabled=FALSE\r\n*._enable_reliable_latch_waits=FALSE\r\n*._enable_NUMA_optimization=FALSE       ### bug 7171446\r\n*._db_block_numa = 1                    ### bug 7171446\r\n\r\n### *._optimizer_autostats_job=false      ### Turn off automatic statistics.\r\n### *.lock_sga    = true\r\n*.distributed_lock_timeout = 100    ### Txtime < SesTm < DistLockTimeout for XA\r\n\r\n\r\n###########################################\r\n# Bug\r\n###########################################\r\n*._gc_affinity_time=0               ### bug4940890 diable DRM (RAC)  Bug 6018125  Instance crash Fixed 10.2.0.4\r\n*._gc_undo_affinity=FALSE           ### diable DRM (RAC)\r\n*._gc_maximum_bids=8                ### (RAC)\r\n\r\n*._rowsource_execution_statistics=TRUE  ### sql info (cr=59 r=52 w=0 time=111599 us)\r\n\r\n*.star_transformation_enabled=FALSE     ### Bug 6318487 fixed 10.2.0.5\r\n*._object_statistics=FALSE              ### Bug    more than 16 CPU\r\n\r\n*._optimizer_push_pred_cost_based=FALSE ### Bug\r\n*._optimizer_connect_by_cost_based=FALSE ### Bug after 10.2.0.2\r\n*._optimizer_cost_based_transformation=OFF ### Bug 6815733 fixed 10.2.0.5, Bug 6795926 Bug 6310653 Bug 6183577 Bug 6061623\r\n\r\n*._complex_view_merging=FALSE           ### Bug 6634836 Bug 6316585 Bug 6276590 fixed 10.2.0.5, Bug 7189447\r\n*._subquery_pruning_enabled=FALSE       ### Bug 6714608 fixed 10.2.0.5\r\n*._bloom_filter_enabled=FALSE           ### Bug 5766718 Bug 6070877 fixed 10.2.0.5\r\n*._b_tree_bitmap_plans=FALSE            ### Bug 6122097 fixed 10.2.0.5, Bug 6653704 Bug 6525496\r\n\r\n\r\n### *._optimizer_skip_scan_enabled=FALSE ### Bug 6070954 Fixed 10.2.0.4\r\n### *._db_fast_obj_truncate = FALSE   ### Bug 5575748 enq: RO - fast object reuse\r\n\r\n### *.db_cache_advice=READY        ## Bug 5918642 Fixed 10.2.0.4\r\n### *._library_cache_advice=FALSE  ## Bug 4697252 Fixed 10.2.0.4\r\n### *._ash_enable=false\r\n\r\n\r\n###########################################\r\n# Diagnostics and Events\r\n###########################################\r\n*.event=\"10246 trace name context forever, level 1\"\r\n*.event=\"10511 trace name context forever, level 1\"  ## Disable undo offline\r\n*.event=\"10422 trace name context forever, level 1\"  ## control enqueue while startup\r\n*.event=\"240 debug\"                                  ## control enqueue while startup\r\n*.event = \"4031 trace name ERRORSTACK level 3\"       ## 4031 issue\r\n*.event = \"4031 trace name LIBRARY_CACHE level 10\"   ## 4031 issue\r\n*.event = \"4031 trace name heapdump level 2\"         ## 4031 issue\r\nmax_dump_file_size = unlimited                       ## 4031 issue\r\n_oradbg_pathname=\"\/oraom\/users\/kkm\/oradbg\"           ## control enqueue while startup\r\n# *.event=\"29740 trace name errorstack level 3\" ### for evict (RAC)\r\n# *.event=\"481 trace name errorstack level 3\"   ### for LMON  (RAC)\r\n# *.event=\"484 trace name errorstack level 3\"   ### for LMS   (RAC)\r\n# *.event=\"470 trace name errorstack level 3\"   ### for LGWR<\/pre>\n","protected":false},"excerpt":{"rendered":"
Oracle 3-node RAC \uc5d0\uc11c\u00a0 Oracle 10g R2 \ubc84\uc804\u00a0 DB\uc758 \ud30c\ub77c\ubbf8\ud130 init.ora \uad00\ub9ac \uc608\uc2dc …. \uae08\uc735\uad8c \uc774\ub098 \ud2b8\ub798\ud53d\uc774 \uad49\uc7a5\ud788 \ub9ce\uc740 \ud14c\ub77c\uae09 \uc0ac\uc774\ud2b8\ub294 PFILE \ud615\ud0dc \ub85c init.ora \ud30c\uc77c\uc744 \ud0c0\uc774\ud2b8\ud558\uac8c \uc9c1\uc811 DBA \uac00 \uad00\ub9ac \ud569\ub2c8\ub2e4.   ############################################################################## # haisins oracle 10g Release 2 RAC 3 node ############################################################################## ########################################### # Archive ########################################### *.log_archive_dest_1=’LOCATION=\/ora_arch\/ORADB MANDATORY REOPEN=5′ #haisins *.log_archive_format=arch_ORADB_%r_%t_%s.dbf *.log_checkpoints_to_alert=TRUE #haisins […]<\/p>\n","protected":false},"author":1,"featured_media":2875,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[21],"tags":[553,968,967,969,472,376,970],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3260"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3260"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3260\/revisions"}],"predecessor-version":[{"id":3261,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3260\/revisions\/3261"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2875"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3260"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}