{"id":406,"date":"2015-08-24T04:34:16","date_gmt":"2015-08-24T04:34:16","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=406"},"modified":"2015-08-24T04:34:16","modified_gmt":"2015-08-24T04:34:16","slug":"sqldbms-%ed%8a%9c%eb%8b%9d%ea%b3%bc-%ea%b4%80%eb%a0%a8%eb%90%98-%ec%98%a4%eb%9d%bc%ed%81%b4-db-%ed%8c%8c%eb%9d%bc%eb%a9%94%ed%84%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=406","title":{"rendered":"SQL\/DBMS \ud29c\ub2dd\uacfc \uad00\ub828\ub418 \uc624\ub77c\ud074 DB \ud30c\ub77c\uba54\ud130"},"content":{"rendered":"<p><\/p>\n<p>&nbsp; &nbsp; &nbsp;[ Query Optimizing ]<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _optim_peek_user_binds=FALSE<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : _optim_peek_user_binds=TRUE\uc77c \uacbd\uc6b0 Bind Value\uac00 \uc788\ub294 SQL\uc758 \ud574\uc11d\uacfc<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; FALSE\uc77c \uacbd\uc6b0\uc5d0 \ud574\uc11d\ub418\ub294 \uac83\uc5d0 \ub9ce\uc740 \ucc28\uc774\uac00 \uc788\ub2e4. TRUE\uc77c \uacbd\uc6b0 Bind Value\uc5d0&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc778\ub371\uc2a4\uac00 \uc788\uace0, \ud574\ub2f9 SQL\uc774 Bind Value\ub97c \uc774\uc6a9\ud574\uc11c \ud574\uc11d\uc774 \ub418\uc5b4\uc57c \ud558\ub294 \uacbd\uc6b0<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; Query Optimizer\uac00 Bind Value\uc758 Column Histogram\uc744 \ucc38\uc870\ud558\uc5ec SQL\ubb38\uc744 \ud574\uc11d<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ud558\uace0 \uc2e4\ud589\ud558\uac8c \ub428. \uc774\ub54c, \ud3c9\uc0c1\uc2dc \uc870\ud68c\uac00 \ub418\uc9c0 \uc54a\ub294 \uc870\uac74\uc73c\ub85c Binding\uc774 \ub420\uacbd\uc6b0<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ud3c9\uc0c1\uc2dc\uc758 PLAN\uacfc \uc0c1\uc774\ud558\uac8c \ud574\uc11d\ub420 \uc218 \uc788\uc73c\uba70, \ud574\ub2f9 SQL\uc758 Cursor\uac00 Aging Out<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ub418\uc9c0 \uc54a\ub294 \ub3d9\uc548\uc5d0\ub294 PLAN\uc774 \uc720\uc9c0\ub418\uac8c \ub41c\ub2e4. Aging Out \ub41c \uc774\ud6c4\uc5d0\ub294 \ub610\ub2e4\uc2dc&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; Column Histogram\uc744 \ucc38\uc870\ud558\uc5ec PLAN\uc744 \uc138\uc6b0\uac8c \ub418\uc5b4 \uc774\uc804\uacfc\ub294 \uc0c1\uc774\ud55c \uc2e4\ud589\uacc4\ud68d<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc774 \uc218\ub9bd\ub418\uc5b4 SQL\uc774 \uc2e4\ud589\ub420 \uc218 \uc788\ub2e4. False\uc77c \uacbd\uc6b0\uc5d0\ub294 \uc77c\ubc18\uc801\uc778 Query Optimizing<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc744 \ud558\uac8c \ub41c\ub2e4. (\ud544\uc218\uc801\uc6a9\uc0ac\ud56d)<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _b_tree_bitmap_plans=FALSE<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : Query Optimizer\uac00 SQL \ud574\uc11d\ud560 \ub54c Where\uc808\uc5d0 \uc5ec\ub7ec \uc870\uac74\uc774 \uc788\uace0, \ud574\ub2f9 \uc870\uac74<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uceec\ub7fc\ub4e4\uc5d0 Index\uac00 \uac01\uac01 \uc0dd\uc131\ub418\uc5b4 \uc788\uc744 \uacbd\uc6b0 B*tree Index\ub97c Bitmap\uc73c\ub85c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; conversion\ud558\uc5ec PLAN\uc744 \uc218\ub9bd\ud558\uc5ec \uc2e4\ud589\ud568. \uc774\ub7f4\uacbd\uc6b0 TYPE\uc774\ub098 Code\uc131 \uceec\ub7fc\uc758<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uacbd\uc6b0 B*tree Index range scan\uc73c\ub85c \ud574\uc11d\ub418\ub294 \uacbd\uc6b0\ubcf4\ub2e4 \uc131\ub2a5\uc774 \ub098\uc744\uc218 \uc788\uc73c\ub098<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc77c\ubc18\uc801\uc73c\ub85c \uc131\ub2a5\uc774 \uc800\ud558\ub418\ub294 \uacbd\uc6b0\uac00 \ub354 \ub9ce\uc74c.(\ud544\uc218\uc801\uc6a9\uc0ac\ud56d)<\/p>\n<p><\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; optimizer_mode=&#8217;FIRST_ROWS_100&#8242;<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : 10g R1\uc5d0\uc11c\ub294 optimizer_mode\ub97c first_rows\ub85c \uc124\uc815\uacfc \uad00\ub828\ub41c Bug\uc774 \uc788\uc5c8\uc74c.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uadf8\ub9ac\uace0, \uc628\ub77c\uc778(OLTP) \ud658\uacbd\uc5d0\uc11c\ub294 First_rows \uc124\uc815\uc774 \uc544\ub2cc First_rows_100<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc815\ub3c4 \uc138\ud305\ud558\ub294\uac83\uc774 \uc720\ub9ac\ud568.<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _optimizer_sortmerge_join_enabled=FALSE<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : Merge Join Cartesian(Merge Join)\uc744 \uc5c6\uc560\uae30 \uc704\ud55c \ud30c\ub77c\ubbf8\ud130 \uc138\ud305\uc73c\ub85c,&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cartesian Product\ub294 Join Ker\uac00 \uc5c6\uc774 Join\uc774 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 \ubc1c\uc0dd\ub418\ub294\uac8c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;\uc815\uc0c1\uc774\ub098 \ube44\uc815\uc0c1\uc801\uc73c\ub85c Merge Join Cartesian\uc774 \ubc1c\uc0dd\ub418\uc5b4 SQL\ub4e4\uc758 \uc2e4\ud589\uacc4\ud68d<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;\uc774 \ube44\uc815\uc0c1\uc801\uc73c\ub85c \uc218\ub9bd \ubc0f \uc2e4\ud589\ub418\uc5b4 \uc131\ub2a5\uc800\ud558\uac00 \ub9ce\uc774 \ubc1c\uc0dd\ud558\uc5ec \uc801\uc6a9\uc744 \ud568.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;\uc8fc\uc758\ud560 \uc810\uc740 cartesian Product\uac00 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 Nested Loop\ub85c PLAN\uc5d0 \ud574\uc11d\ub418<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;\ubbc0\ub85c, PLAN \ud574\uc11d\ud560 \ub54c\uc5d0 \uc720\uc758\ud558\uc5ec\uc57c \ud568.(\ud544\uc218\uc801\uc6a9\uc0ac\ud56d)<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; [ Scalar Subquery ]<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _query_execution_cache_max_size=4194304&nbsp;<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : SQL \uc218\ud589 \uc2dc select list clause\uc5d0\uc11c function call \uacfc\ub2e4\uc5d0 \uc758\ud55c \uc131\ub2a5\ubd80\ud558\uac00 \uc2ec\ud560&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uacbd\uc6b0\uac00 \ub9ce\uc774 \uc788\ub2e4. \uadf8\ub7f4\uacbd\uc6b0\uc5d0\ub294 function call \ubd80\ubd84\uc744 \uc2a4\uce7c\ub77c\uc11c\ube0c\ucffc\ub9ac\ub85c \ubcc0\uacbd\ud558\uc5ec&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; function call\uc5d0 \uc758\ud55c \ubd80\ud558\ub97c \ucd5c\uc18c\ud654 \ud560 \ud544\uc694\uac00 \uc788\ub2e4. \uc774\ub7f4\uacbd\uc6b0 \uc2a4\uce7c\ub77c \uc11c\ube0c\ucffc\ub9ac\ub97c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc704\ud55c buffer cache \uc601\uc5ed\uc744 \ub298\ub824\uc8fc\uc5b4\uc57c \ud558\uba70, _query_execution_cache_max_size \ub85c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uba54\ubaa8\ub9ac \uc0ac\uc774\uc988\ub97c \ub298\ub824\uc8fc\uc5b4\uc57c \ud55c\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c OLTP \ud658\uacbd\uc5d0\uc11c\ub294 4M \uc815\ub3c4\uac00 \uc801\ub2f9\ud558\uba70<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; Function Call\uc744 \uc2a4\uce7c\ub77c \uc11c\ube0c\ucffc\ub9ac\ub85c \ubcc0\uacbd\ud560 \uacbd\uc6b0 \uc2a4\uce7c\ub77c \uc11c\ube0c\ucffc\ub9ac buffer cache<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ubcc0\uacbd\uc678\uc5d0 \ub610\ub2e4\ub978 \uc8fc\uc758\ud560 \uc0ac\ud56d\uc774 \uc788\ub294\ub370, Function Call\uc5d0 \uc758\ud574 \ub370\uc774\ud130\ub97c \ub9ac\ud134\ubc1b\uc744 \ub54c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \ub9ac\ud134\ubc1b\ub294 \ub370\uc774\ud130\ub97c \uc704\ud558\uc5ec varchar2(4000) \ub9cc\ud07c Memory \uc601\uc5ed\uc744 \uc810\uc720\ud558\uac8c \ub418\ubbc0\ub85c,&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; substr()\ub85c \uc801\uc815\ud558\uac8c \uc0ac\uc774\uc988\ub97c \ub450\uc5b4 \ube44\ud6a8\uc728\uc801\uc73c\ub85c \uc635\ud2f0\ub9c8\uc774\uc800\uac00 \uba54\ubaa8\ub9ac\ub97c \uc810\uc720\ud558\uc9c0&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc54a\uac8c \ud558\uc5ec\uc57c \ud55c\ub2e4. (\ud544\uc218\uc801\uc6a9\uc0ac\ud56d)<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; [ Parallel ]<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _PX_use_large_pool=TRUE<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : Use Large Pool as source of PX buffers<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; parallel_automatic_tuning=TRUE<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; parallel_execution_message_size=64k (\ud544\uc218\uc801\uc6a9\uc0ac\ud56d)<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; parallel_instance_group=&#8217;A&#8217;<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; parallel_max_servers=80<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; [ Index ]<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _index_join_enabled=FALSE<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : Index Join Disable<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _fast_full_scan_enabled=TRUE (default\uac00 TRUE)<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _optimizer_skip_scan_enabled=FALSE<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : Index Skip Scan\uc774 \ub418\uc9c0 \uc54a\uac8c \ud558\uae30\uc704\ud55c \ud30c\ub77c\ubbf8\ud130\uc784.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&gt; Index Skip Scan\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uc5d0\ub294 10g\ubd80\ud130 \uc9c0\uc6d0\ub418\ub294 opt_param() \ud78c\ud2b8\ub97c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;\uc0ac\uc6a9\ud558\uc5ec SQL Level\uc5d0\uc11c Index Skip Scan\uc774 \ub418\uac8c\ub054 \ubc14\uafd4\uc8fc\uba74 \ub428.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;( \/*+ opt_param(&#8216;_OPTIMIZER_SKIP_SCAN_ENABLED&#8217;,&#8217;FALSE&#8217;) *\/ )<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&gt; Index Skip Scan\uc774 False\uc77c \uacbd\uc6b0 Skip Scan\uc774 \ub418\uc9c0 \uc54a\uc9c0\ub9cc, Index Column\uc778<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;\uacbd\uc6b0\uc5d0 Index Filter\uac00 \ub418\uae30\ub54c\ubb38\uc5d0 \uc131\ub2a5\uc0c1 \ub9ce\uc740 \uc601\ud5a5\uc740 \uc5c6\uc74c)<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; optimizer_index_caching=90 (default 0)<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : \uc774 \ud30c\ub77c\uba54\ud130\ub294 0~99 \uc0ac\uc774\uc758 \uac12\uc744 \uc124\uc815 \ud560 \uc218 \uc788\uc73c\uba70, 0\uc77c \uacbd\uc6b0\uc5d0\ub294 Index\ub97c \uc774\uc6a9\ud574\uc11c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; Access\ub418\ub294 block \ub4e4\uc774 SGA\uc758 Buffer Cache \uc601\uc5ed\uc5d0\uc11c \ucc3e\uc744 \uc218 \uc788\ub294 \ube44\uc728\uc774 0%\ub780&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc758\ubbf8\uc774\ub2e4.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc989 \ubaa8\ub4e0 index access\ub294 DISK I\/O \ub97c \ubc1c\uc0dd\ud558\uc5ec Physical Reads\ub97c \uc218\ud589 \ud55c \ud6c4\uc5d0 Buffer<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; cache\ub85c\ubd80\ud130 Logical reads\ub97c \uc218\ud589\ud55c\ub2e4\ub294 \uc758\ubbf8\uac00 \ub41c\ub2e4. \uc774 \ud30c\ub77c\uba54\ud130\ub294 CBO\uc5d0\uc11c Index&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; block\uc744 access\ud560\ub54c \uc18c\uc694\ub418\ub294 Cost\ub97c \uacc4\uc0b0\ud558\uae30 \uc704\ud55c \ube44\uc728\ub85c\uc11c \uc0ac\uc6a9\ub418\uc5b4\uc9c4\ub2e4.<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; optimizer_index_cost_adj=10<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : \uc774 \ud30c\ub77c\uba54\ud130\ub294 1~10000\uc0ac\uc774\uc758 \uac12\uc744 \uc124\uc815\ud560\uc218 \uc788\uc73c\uba70 Index access\uc640 Full Table Scan<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 Physical I\/O \uc758 Cost\uc758 \uc0c1\ub300\uc801\uc778 \ube44\uc728\uc744 \uc124\uc815\ud558\ub294 \ud30c\ub77c\uba54\ud130\uc774\ub2e4.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; 100\uc778\uacbd\uc6b0\uc5d0\ub294 \ub450\uac1c\uc758 access \ubaa8\ub450 \ub3d9\uc77c\ud55c \ube44\uc728\ub85c Cost\ub97c \uacc4\uc0b0\ud558\uac8c\ub418\uba70 50\uc73c\ub85c \uc124\uc815\ud558<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc5ec &nbsp;Index access\ub97c \ud558\ub294 \uacbd\uc6b0 \uae30\uc874\uc758 cost\uc758 1\/2\ub85c cost\ub97c \uacc4\uc0b0\ud558\uac8c \ub418\uc5b4, Index&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; access \ubc29\uc2dd\uc73c\ub85c execution plan\uc774 \uc218\ub9bd\ub418\uc5b4\uc9c8 \ud655\ub960\uc774 \ub192\uc544\uc9c0\uac8c \ub41c\ub2e4. Optimizer_mode<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ub97c first_rows\ub85c \uc124\uc815\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c optimizer_index_cost_adj \ub294 10\uc73c\ub85c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uacc4\uc0b0\ub418\uc5b4\uc9c4\ub2e4. \ub530\ub77c\uc11c Index access\ub97c \uc774\uc6a9\ud558\uc5ec execution plan\uc744 \uc218\ub9bd\ud560 \ud655\ub960\uc774 \ub192\uc544<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc9c0\uac8c \ub418\uba74 Join\uc778 \uacbd\uc6b0\uc5d0\ub294 Nested Loops Join\uc73c\ub85c execution plan\uc774 \uc218\ub9bd\ub420 \uac00\ub2a5\uc131\uc774<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ub192\uc544\uc9c0\uac8c \ub41c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; [ I\/O Count ]<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _hash_multiblock_io_count=32<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; _sort_multiblock_read_count=32<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; db_file_multiblock_read_count=32<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; [ DB Link ]<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; open_links=50<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : &nbsp;\ud55c \uc138\uc158\uc5d0\uc11c Remote Database\ub85c \ub3d9\uc2dc\uc5d0 \uc5f0\uacb0\ud560 \uc218 \uc788\ub294 \ucd5c\ub300 \uc218<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -&gt; 8.1.7 \uc774\uc804 \ubc84\uc804\uc5d0\uc11c open_links\uc758 \uc124\uc815\uac12\uc744 255\ub97c \ucd08\uacfc\ud558\uc5ec \uc124\uc815\uc2dc&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORA-600 [k2rcbk: null gti] Internal Error \ubc1c\uc0dd\ud568. open_links \uc124\uc815\uc2dc<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 255\ub97c \ucd08\uacfc\ud558\uba74 \uc548\ub428. (Bug no. 1035278)<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -&gt; ora-600 [npiane0] Internal Error \ubc1c\uc0dd (Bug 1092735)<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; open_links \uac12\uc744 \ucd08\uacfc\ud558\uc5ec connection \uc2dc\ub3c4\uc2dc \ubc1c\uc0dd<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; open_links_per_instance=1000<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; [ Cursor ]<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; open_cursors=300<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; cursor_space_for_time=TRUE<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : \uc138\uc158\uc5d0\uc11c \uc0ac\uc6a9\ub41c Cursor\ub97c \uc138\uc158\uc774 \ub2eb\ud790 \ub54c\uae4c\uc9c0 SGA\uc5d0 \ub0a8\uaca8\ub193\ub294\ub2e4.<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; session_cached_cursors=50<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; : \uc5f4\ub824\uc788\ub294 \uc138\uc158\uc774 \uac00\uc9c8 \uc218 \uc788\ub294 \ucd5c\ub300 Cursors \uac1c\uc218<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; SESSION_CACHED_CURSORS \ud30c\ub77c\uba54\ud130\ub294 \ub3d9\uc77c\ud55c SQL\uc744 \ubc18\ubcf5\uc218\ud589\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc720\ub9ac\ud558\uba70,<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ubcf4\ud1b5 softer parse \ub77c\uace0 \ud55c\ub2e4.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ub2e8, \ub9ac\ud130\ub7f4 SQL\uc774 \ub9ce\uc740 \uacbd\uc6b0\uc5d0\ub294 \uc0ac\uc6a9\uc744 \ud53c\ud574\uc57c \ub41c\ub2e4.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ubaa8\ub4c8\ubcc4\ub85c \ud2b9\uc815 SQL \ub4e4\uc744 \ubc18\ubcf5 \uc218\ud589\ud558\ub294 \uc138\uc158\ub4e4\uc5d0 \uc124\uc815\uc2dc SOFT \ud30c\uc2f1\ubd80\ud558\ub97c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uac10\uc18c\uc2dc\ucf1c\uc900\ub2e4. \uc2dc\uc2a4\ud15c\uc774 \ub0b4\ubd80 \uc218\ud589\ud558\ub294 ReCursive SQL \ub3c4 \ud3ec\ud568\ub418\ubbc0\ub85c \ucd5c\uc18c 30 \uc774\ud558\ub85c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc124\uc815\ud558\ub294\uac83\uc740 \ud6a8\uacfc\uac00 \uc5c6\uc73c\uba70 \ubcf4\ud1b5 50 \uc815\ub3c4\ub97c \uad8c\uc7a5\ud55c\ub2e4.<\/p>\n<p><\/p>\n<p>&nbsp; &nbsp; &nbsp;&#8211; cursor_sharing=force \uc4f8 \uacbd\uc6b0 \ucffc\ub9ac\uc5d0 rownum = 1\uc778 \ucffc\ub9ac\uac00 \uc788\ub2e4\uba74 \uc774 \ubd80\ubd84\uc774 rownum := :b1\uc774\ub7f0\uc2dd\uc73c\ub85c&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \ubc14\uc778\ub4dc \ubcc0\uc218 \ucc98\ub9ac\uac00 \ub418\uc5b4\uc11c \ubd80\ubd84\ubc94\uc704 \ucc98\ub9ac\uac00 \ub418\uc9c8 \ubabb\ud55c\ub2e4.<\/p>\n<p>&nbsp; &nbsp; &nbsp; &nbsp; \uc774\ub7f4 \uacbd\uc6b0\ub97c \ub300\ube44\ud574\uc11c rownum &lt;= 1 \uc774\ub7f0\uc2dd\uc73c\ub85c SQL \uc0dd\uc131 \uc2b5\uad00\uc744 \ub4e4\uc774\uc790<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; [ SGA ]<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; db_cache_size=4G<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; db_keep_cache_size=2G<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; java_pool_size=16777216<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; large_pool_size=52428800<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; log_buffer=14473216<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; pga_aggregate_target=4G<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; shared_pool_size=1200M<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; shared_pool_reserved_size=100M<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; sga_max_size=7400M<\/p>\n<p>&nbsp; &nbsp; &nbsp; &#8211; sga_target=7400M<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; &nbsp; &nbsp;[ Query Optimizing ] &nbsp; &nbsp; &nbsp; &nbsp; &#8211; _optim_peek_user_binds=FALSE &nbsp; &nbsp; &nbsp; &nbsp; : _optim_peek_user_binds=TRUE\uc77c \uacbd\uc6b0 Bind Value\uac00 \uc788\ub294 SQL\uc758 \ud574\uc11d\uacfc &nbsp; &nbsp; &nbsp; &nbsp; FALSE\uc77c \uacbd\uc6b0\uc5d0 \ud574\uc11d\ub418\ub294 \uac83\uc5d0 \ub9ce\uc740 \ucc28\uc774\uac00 \uc788\ub2e4. TRUE\uc77c \uacbd\uc6b0 Bind Value\uc5d0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \uc778\ub371\uc2a4\uac00 \uc788\uace0, \ud574\ub2f9 SQL\uc774 Bind Value\ub97c \uc774\uc6a9\ud574\uc11c \ud574\uc11d\uc774 \ub418\uc5b4\uc57c \ud558\ub294 \uacbd\uc6b0 &nbsp; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[11],"tags":[129,130,131],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/406"}],"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=406"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/406\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=406"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}