{"id":3556,"date":"2018-02-05T09:15:37","date_gmt":"2018-02-05T00:15:37","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3556"},"modified":"2018-02-05T09:15:37","modified_gmt":"2018-02-05T00:15:37","slug":"tiporacle-12c-%ec%9d%98-spfile-%ec%98%88","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3556","title":{"rendered":"[TIP]Oracle 12c \uc758 spfile \uc608 …"},"content":{"rendered":"

Z \uc0ac Case \uacf5\uc720 ….<\/p>\n

HW
\n—————————–
\nAIX P8 8XX
\nCPU 11 core (\uac01\ub178\ub4dc\ubcc4)
\nPhysical Memory 220G<\/p>\n

SGA
\n—————————–
\nSGA_TARGET 0
\nSGA_MAX_SIZE 67584M
\nDB_CACHE_SIZE 47308M
\nSHARED_POOL_SIZE 10240M
\nLARGE_POOL_SIZE 2048M
\nJAVA_POOL_SIZE 1024M
\nSTREAMS_POOL_SIZE 1024M
\nSGA_MAX Size \ud569\uacc4 51404M
\nprocesses 5000
\npga_aggregate_target 45056M
\nprocesses 7864M >
\nKEEP 1024M
\n—————————-
\nSGA\ucc28\uc774 16179M<\/p>\n

Params
\n—————————–
\nalter system set “_add_col_optim_enabled” = FALSE scope=spfile;
\nalter system set “_b_tree_bitmap_plans” = FALSE scope=spfile;
\nalter system set “_bloom_filter_enabled” = FALSE scope=spfile;
\nalter system set “_cleanup_rollback_entries” = 500 scope=spfile;
\nalter system set “_clusterwide_global_transactions” = FALSE scope=spfile;
\nalter system set “_cursor_features_enabled” = 10 scope=spfile;
\nalter system set “_db_mttr_advice” = OFF scope=spfile;
\nalter system set “_enable_NUMA_optimization” = FALSE scope=spfile;
\nalter system set “_gc_bypass_readers” = FALSE scope=spfile;
\nalter system set “_gc_integrity_checks” = 0 scope=spfile;
\nalter system set “_gc_policy_time” = 0 scope=spfile;
\nalter system set “_gc_read_mostly_locking” = FALSE scope=spfile;
\nalter system set “_gc_undo_affinity” = FALSE scope=spfile;
\nalter system set “_in_memory_undo” = FALSE scope=spfile;
\nalter system set “_library_cache_advice” = FALSE scope=spfile;
\nalter system set “_memory_imm_mode_without_autosga” = FALSE scope=spfile;
\nalter system set “_object_statistics” = FALSE scope=spfile;
\nalter system set “_optim_peek_user_binds” = FALSE scope=spfile;
\nalter system set “_optimizer_adaptive_cursor_sharing” = FALSE scope=spfile;
\nalter system set “_optimizer_connect_by_cost_based” = FALSE scope=spfile;
\nalter system set “_optimizer_order_by_elimination_enabled” = FALSE scope=spfile;
\nalter system set “_optimizer_push_pred_cost_based” = FALSE scope=spfile;
\nalter system set “_optimizer_use_feedback” = FALSE scope=spfile;
\nalter system set “_partition_large_extents” = FALSE scope=spfile;
\nalter system set “_PX_use_large_pool” = TRUE scope=spfile;
\nalter system set “_rollback_segment_count” = 1000 scope=spfile;
\nalter system set “_row_cr” = FALSE scope=spfile;
\nalter system set “_undo_autotune” = FALSE scope=spfile;
\nalter system set “_use_adaptive_log_file_sync” = FALSE scope=spfile;
\nalter system set “audit_trail” = NONE scope=spfile;
\nalter system set “DB_CACHE_ADVICE” = OFF scope=spfile;
\nalter system set “DB_FILE_MULTIBLOCK_READ_COUNT” = 32 scope=spfile;
\nalter system set “db_files” = 2000 scope=spfile;
\nalter system set “deferred_segment_creation” = FALSE scope=spfile;
\nalter system set “FAST_START_MTTR_TARGET” = 180 scope=spfile;
\nalter system set “max_dump_file_size” = ‘1G’ scope=spfile;
\nalter system set “open_cursors” = 2000 scope=spfile;
\nalter system set “open_links” = 40 scope=spfile;
\nalter system set “open_links_per_instance” = 40 scope=spfile;
\nalter system set “optimizer_dynamic_sampling” = 0 scope=spfile;
\nalter system set “OPTIMIZER_MODE” = FIRST_ROWS_10 scope=spfile;
\nalter system set “optimizer_index_cost_adj” = 80 scope=spfile;
\nalter system set “parallel_force_local” = TRUE scope=spfile;
\nalter system set “PARALLEL_MAX_SERVERS” = 32 scope=spfile;
\nalter system set “resource_manager_plan” = FORCE scope=spfile;
\nalter system set “session_cached_cursors” = 300 scope=spfile;
\nalter system set “undo_retention” = 3600 scope=spfile;<\/p>\n","protected":false},"excerpt":{"rendered":"

Z \uc0ac Case \uacf5\uc720 …. HW —————————– AIX P8 8XX CPU 11 core (\uac01\ub178\ub4dc\ubcc4) Physical Memory 220G SGA —————————– SGA_TARGET 0 SGA_MAX_SIZE 67584M DB_CACHE_SIZE 47308M SHARED_POOL_SIZE 10240M LARGE_POOL_SIZE 2048M JAVA_POOL_SIZE 1024M STREAMS_POOL_SIZE 1024M SGA_MAX Size \ud569\uacc4 51404M processes 5000 pga_aggregate_target 45056M processes 7864M > KEEP 1024M —————————- SGA\ucc28\uc774 16179M Params —————————– alter system set “_add_col_optim_enabled” […]<\/p>\n","protected":false},"author":1,"featured_media":2505,"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":[20],"tags":[1010,1009,472],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/cropped-12c_social_400x400.png?fit=512%2C512","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3556"}],"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=3556"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3556\/revisions"}],"predecessor-version":[{"id":3557,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3556\/revisions\/3557"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2505"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3556"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}