{"id":561,"date":"2012-08-14T08:05:12","date_gmt":"2012-08-14T08:05:12","guid":{"rendered":"http:\/\/mojtabanow.info\/web\/?p=561"},"modified":"2012-10-17T03:38:07","modified_gmt":"2012-10-17T03:38:07","slug":"%d8%a3%d8%b3%d8%a7%d8%b3%d9%8a%d8%a7%d8%aa-%d9%88%d9%85%d9%87%d8%a7%d8%b1%d8%a7%d8%aa-%d8%aa%d8%ad%d8%b3%d9%8a%d9%86-%d8%a7%d8%af%d8%a7%d8%a1-%d9%82%d8%a7%d8%b9%d8%af%d8%a9-%d8%a8%d9%8a%d8%a7%d9%86","status":"publish","type":"post","link":"https:\/\/qdatabyte.com\/?p=561","title":{"rendered":"\u0623\u0633\u0627\u0633\u064a\u0627\u062a \u0648\u0645\u0647\u0627\u0631\u0627\u062a \u062a\u062d\u0633\u064a\u0646 \u0627\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644"},"content":{"rendered":"<p>\u0633\u0644\u0627\u0645<\/p>\n<p>\u0627\u0644\u0646\u0642\u0627\u0637 \u0627\u0644\u062a\u0627\u0644\u064a\u0629 \u062a\u0639\u062a\u0628\u0631 \u0627\u0633\u0627\u0633 \u0644\u062a\u062d\u0633\u064a\u0646 \u0627\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 , \u062d\u0627\u0648\u0644\u062a \u0627\u0644\u0623\u062e\u062a\u0635\u0627\u0631 \u0628\u0642\u062f\u0631 \u0627\u0644\u0625\u0645\u0643\u0627\u0646<\/p>\n<p align=\"right\">\u0645\u0647\u0627\u0631\u0627\u062a \u0648\u0623\u0633\u0627\u0633\u064a\u0627\u062a \u062a\u062d\u0633\u064a\u0646 \u0627\u062f\u0627\u0621 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a :<\/p>\n<p align=\"right\">\u0627\u0648\u0644\u0627 \u0627\u0644\u0623\u0635\u062f\u0627\u0631\u0627\u062a \u0639\u0644\u0649 \u0645\u0639\u0645\u0627\u0631\u064a\u0629 32 \u0628\u062a<\/p>\n<div align=\"center\">\n<table width=\"454\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td width=\"251\">\n<p align=\"right\"><strong>OS<\/strong><\/p>\n<\/td>\n<td width=\"137\">\n<p align=\"right\"><strong>10<em>g<\/em>R2<\/strong><\/p>\n<\/td>\n<td width=\"125\">\n<p align=\"right\"><strong>11<em>g<\/em>R1<\/strong><\/p>\n<\/td>\n<td width=\"141\">\n<p align=\"right\"><strong>11<em>g<\/em>R2<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"251\">\n<p align=\"right\">Windows XP Professional<\/p>\n<\/td>\n<td width=\"137\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td width=\"125\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td width=\"141\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"251\">\n<p align=\"right\">Windows Server 2003 and Windows Server 2003 R2<\/p>\n<\/td>\n<td width=\"137\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td width=\"125\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td width=\"141\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"251\">\n<p align=\"right\">Windows Vista<\/p>\n<\/td>\n<td width=\"137\">\n<p align=\"right\">10.2.0.4<\/p>\n<\/td>\n<td width=\"125\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td width=\"141\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"251\">\n<p align=\"right\">Windows 7<\/p>\n<\/td>\n<td width=\"137\">\n<p align=\"right\">10.2.0.5<\/p>\n<\/td>\n<td width=\"125\">\n<p align=\"right\">No<\/p>\n<\/td>\n<td width=\"141\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"251\">\n<p align=\"right\">Windows Server 2008<\/p>\n<\/td>\n<td width=\"137\">\n<p align=\"right\">10.2.0.4<\/p>\n<\/td>\n<td width=\"125\">\n<p align=\"right\">11.1.0.7<\/p>\n<\/td>\n<td width=\"141\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<figure id=\"attachment_562\" aria-describedby=\"caption-attachment-562\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/mojtabanow.info\/web\/wp-content\/uploads\/2012\/08\/Picture1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-562\"  title=\"\"  src=\"http:\/\/mojtabanow.info\/web\/wp-content\/uploads\/2012\/08\/Picture1-300x161.png\"  alt=\"Picture1-300x161 \u0623\u0633\u0627\u0633\u064a\u0627\u062a \u0648\u0645\u0647\u0627\u0631\u0627\u062a \u062a\u062d\u0633\u064a\u0646 \u0627\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 \"  width=\"300\" height=\"161\" srcset=\"https:\/\/qdatabyte.com\/wp-content\/uploads\/2012\/08\/Picture1-300x161.png 300w, https:\/\/qdatabyte.com\/wp-content\/uploads\/2012\/08\/Picture1-1024x550.png 1024w, https:\/\/qdatabyte.com\/wp-content\/uploads\/2012\/08\/Picture1.png 1276w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-562\" class=\"wp-caption-text\">Oracle database performance , \u0627\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p align=\"right\"><!--more--><\/p>\n<p align=\"right\">\u0639\u0644\u0649 \u0645\u0639\u0645\u0627\u0631\u064a\u0629 64 \u0628\u062a<\/p>\n<div align=\"center\">\n<table width=\"490\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"279\">\n<p align=\"right\"><strong>OS<\/strong><\/p>\n<\/td>\n<td valign=\"top\" width=\"133\">\n<p align=\"right\"><strong>10<em>g<\/em>R2<\/strong><\/p>\n<\/td>\n<td valign=\"top\" width=\"137\">\n<p align=\"right\"><strong>11<em>g<\/em>R1<\/strong><\/p>\n<\/td>\n<td valign=\"top\" width=\"119\">\n<p align=\"right\"><strong>11<em>g<\/em>R2<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"279\">\n<p align=\"right\">Windows Server 2003 for Itanium<\/p>\n<\/td>\n<td valign=\"top\" width=\"133\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td valign=\"top\" width=\"137\">\n<p align=\"right\">No<\/p>\n<\/td>\n<td valign=\"top\" width=\"119\">\n<p align=\"right\">No<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"279\">\n<p align=\"right\">Windows XP, Windows Server 2003,\u00a0 and Windows Server 2003 R2, x64 Editions<\/p>\n<\/td>\n<td valign=\"top\" width=\"133\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td valign=\"top\" width=\"137\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td valign=\"top\" width=\"119\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"279\">\n<p align=\"right\">Windows Vista for x64 systems<\/p>\n<\/td>\n<td valign=\"top\" width=\"133\">\n<p align=\"right\">10.2.0.4<\/p>\n<\/td>\n<td valign=\"top\" width=\"137\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<td valign=\"top\" width=\"119\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"279\">\n<p align=\"right\">Windows 7 for x64 systems<\/p>\n<\/td>\n<td valign=\"top\" width=\"133\">\n<p align=\"right\">10.2.0.5<\/p>\n<\/td>\n<td valign=\"top\" width=\"137\">\n<p align=\"right\">No<\/p>\n<\/td>\n<td valign=\"top\" width=\"119\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"279\">\n<p align=\"right\">Windows Server 2008 for x64 systems<\/p>\n<\/td>\n<td valign=\"top\" width=\"133\">\n<p align=\"right\">10.2.0.4<\/p>\n<\/td>\n<td valign=\"top\" width=\"137\">\n<p align=\"right\">11.1.0.7<\/p>\n<\/td>\n<td valign=\"top\" width=\"119\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"279\">\n<p align=\"right\">Windows Server 2008 R2 for x64 systems<\/p>\n<\/td>\n<td valign=\"top\" width=\"133\">\n<p align=\"right\">10.2.0.5<\/p>\n<\/td>\n<td valign=\"top\" width=\"137\">\n<p align=\"right\">No<\/p>\n<\/td>\n<td valign=\"top\" width=\"119\">\n<p align=\"right\">Yes<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p align=\"right\">\u0645\u0648\u062c\u0647\u0627\u062a :<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062a\u0649 \u062a\u0639\u0645\u0644 \u0639\u0644\u0649 \u0646\u0638\u0627\u0645 32 \u0628\u062a \u062a\u062f\u0639\u0645 \u062d\u062a\u0649 3 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0647<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062a\u0649 \u062a\u0639\u0645\u0644 \u0639\u0644\u0649 \u0646\u0638\u0627\u0645 64 \u0628\u062a \u062a\u062f\u0639\u0645 \u062d\u062a\u0649 8 \u062a\u064a\u0631\u0627\u0628\u0627\u064a\u062a \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0647<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0623\u0643\u0628\u0631 \u062d\u062c\u0645 \u0644\u0645\u0644\u0641 \u0639\u0644\u0649 \u0623\u0648\u0631\u0627\u0643\u0644 \u064a\u0645\u0643\u0646 \u0627\u064a\u0635\u0644 \u0627\u0644\u0649 64 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0623\u0643\u0628\u0631 \u062d\u062c\u0645 \u0644\u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0647\u0648 4 \u0628\u064a\u062a\u0627\u0628\u0627\u064a\u062a<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0644\u062f\u0649 \u0648\u0646\u062f\u0648\u0632 2003 \u0646\u0633\u062e\u0629 \u0627\u0644 64 \u0628\u062a \u0628\u0639\u0636 \u0627\u0644\u0628\u0637\u0621 \u0639\u0646\u062f \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0639\u0646\u062f \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0643\u0645\u064a\u0629 \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u0649 \u0627\u0644\u0630\u0627\u0643\u0631\u0647 \u0627\u062b\u0646\u0627\u0621 \u0648\u0636\u0639 Large Pages \u00a0\u062e\u0635\u0648\u0635\u0627 \u0627\u0630\u0627 \u062a\u0645 \u0639\u0645\u0644 Fragement \u00a0\u0644\u0644\u0630\u0627\u0643\u0631\u0647\u00a0 , \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0643\u0629 \u062a\u0645 \u062d\u0644\u0647\u0627 \u0639\u0644\u0649 \u0648\u0646\u062f\u0648\u0632 2008 .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0643\u0644 \u0623\u0635\u062f\u0627\u0631\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 \u062a\u0639\u0645\u0644 \u0639\u0644\u0649 \u0627\u0644\u0645\u0639\u0627\u0644\u062c\u0627\u062a \u0627\u0644\u062a\u0649 \u062a\u062f\u0639\u0645 Hyper threading<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0647\u0646\u0627\u0643 \u0642\u064a\u0645\u0629 \u064a\u0645\u0643\u0646 \u0648\u0636\u0639\u0647\u0627 \u0628\u0627\u0644\u0631\u064a\u062c\u0633\u062a\u0631\u0649 \u0644\u062a\u062d\u062f\u064a\u062f \u0623\u0649 Thread \u0633\u062a\u0639\u0645\u0644 \u0639\u0644\u0649 \u0623\u0649 Processor \u00a0\u0641\u0649 \u0628\u064a\u0626\u0629 \u0645\u062a\u0639\u062f\u062f\u0629 \u0627\u0644\u0645\u0639\u0627\u0644\u062c\u0627\u062a \u0648\u0627\u0644\u0642\u064a\u0645\u0629 \u0647\u0649 ORACLE_AFFINITY<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u064a\u0645\u0643\u0646 \u062a\u062d\u062f\u064a\u062f \u0627\u0644\u0623\u0648\u0644\u0648\u064a\u0627\u062a \u0641\u0649 \u0627\u0644\u0631\u064a\u062c\u0633\u062a\u0631\u0649 \u00a0\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0642\u064a\u0645\u0629 ORACLE_PRIORITY<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0642\u0645 \u0628\u0623\u0633\u062a\u062e\u062f\u0627\u0645 listener \u0648\u0627\u062d\u062f \u0641\u0642\u0637 \u0644\u0643\u0644 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0639\u0646\u062f \u0648\u062c\u0648\u062f \u0627\u0632\u062f\u062d\u0627\u0645 \u0639\u0646\u062f \u0627\u0644\u062f\u062e\u0648\u0644 \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0642\u0645 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0642\u064a\u0645\u0629 QUEUESIZE \u0641\u0649 \u0645\u0644\u0641 \u0627\u0644 listener.ora \u0644\u0627\u0646 \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0647\u0649 50 \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 200 \u0627\u0648 300 \u0644\u0643\u0646 \u0627\u0633\u062a\u062e\u062f\u0645\u0647\u0627 \u0641\u0642\u0637 \u0641\u0649 \u062d\u0627\u0644\u0629 \u0627\u0644\u062d\u0648\u062c\u0629 \u0627\u0644\u064a\u0647\u0627 .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0645\u0639\u062f\u0644 \u062d\u062c\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0646\u0642\u0648\u0644 \u062e\u0644\u0627\u0644 \u0627\u0644\u0634\u0628\u0643\u0629\u00a0 \u0627\u0644\u0623\u0633\u0627\u0633\u0649 \u0647\u0648 8k \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0648\u0631\u0627\u0643\u0644 11\u062c\u0649\u00a0 \u064a\u0645\u0643\u0646\u0643 \u0632\u064a\u0627\u062f\u0629 \u0647\u0630\u0627 \u0627\u0644\u0645\u0639\u062f\u0644 \u062d\u062a\u0649 32bit \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u00a0 DEFAULT_SDU_SIZE \u00a0\u0641\u0649 \u0645\u0644\u0641 \u0627\u0644 sqlnet.ora \u0627\u0648 SDU \u0641\u0649 \u0645\u0644\u0641 \u0627\u0644 TNSNAMES.ORA<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u00a0 Dedicated Server \u064a\u0639\u0637\u0649 \u0627\u062f\u0627\u0621 \u0648\u0633\u0631\u0639\u0629 \u0623\u0641\u0636\u0644 \u0645\u0639 \u0642\u0627\u0639\u062f\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 Shared server \u00a0\u064a\u0648\u0641\u0631 \u0645\u0633\u0627\u062d\u0629 \u0630\u0627\u0643\u0631\u0629 \u0627\u0643\u0628\u0631 \u0644\u0643\u0646\u0647 \u064a\u0636\u0631 \u0628\u0627\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0648\u0646\u062f\u0648\u0632 \u0641\u064a\u0633\u062a\u0627 \u0648 7 \u06482008 \u064a\u062f\u0639\u0645\u0648\u0646 \u062e\u0627\u0635\u064a\u0629 TCP auto tunning<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0627\u0644\u0642\u064a\u0645\u0629 SQLNET.AUTHENTICATION_SERVICES=(NTS) \u00a0\u0628\u0645\u0644\u0641 sqlnet.ora \u00a0\u062a\u062e\u0635 \u0627\u0644\u062f\u062e\u0648\u0644 \u00a0\u0643 (connect \/ as SYSDBA)<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062e\u0627\u0635\u064a\u0629 Automatic Storage Management\u00a0 &#8211; ASM\u00a0 \u0644\u0646 \u062a\u062d\u062a\u0627\u062c \u0644\u0646\u0642\u0644 \u0645\u0644\u0641\u0627\u062a \u0627\u0644 Datafiles \u0643\u0645\u0627 \u0644\u0646 \u062a\u062d\u062a\u0627\u062c \u0644\u0648\u0636\u0639\u00a0 Tablespace \u00a0\u0641\u0649 \u0648\u0636\u0639 offline \u0628\u0627\u0644\u0627\u0636\u0627\u0641\u0629 \u0644\u0627\u0645\u0643\u0627\u0646\u064a\u0629 \u0627\u0636\u0627\u0641\u0629 \u0647\u0627\u0631\u062f\u0633\u0643 \u0627\u0648 \u0645\u0633\u0627\u062d\u0629 \u0628\u062f\u0648\u0646 \u062a\u0648\u0642\u0641 .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0623\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0642\u064a\u0645\u0629 MEMORY_TARGET \u0644\u0623\u062f\u0627\u0631\u0629 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0627\u0644\u064a\u0627\u064b SGA \u0648 PGA \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0649 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 11g .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0627\u0630\u0627 \u0643\u0627\u0646 \u0628\u0627\u0645\u0643\u0627\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0646\u0633\u062e\u0629 64 \u0628\u062a\u00a0 \u0641\u0644\u0627 \u062a\u0633\u062a\u062e\u062f\u0645 \u0646\u0633\u062e\u0629 32\u0628\u062a \u0648\u0627\u0646\u062a\u0642\u0644 \u0641\u0648\u0631\u0627 \u0627\u0644\u0649 64 \u0628\u062a \u062a\u062d\u0633\u064a\u0646\u0627 \u0644\u0644\u0627\u062f\u0627\u0621 \u0648\u0627\u0628\u062a\u0639\u0627\u062f\u0627 \u0639\u0646 \u0627\u0644\u0645\u0634\u0643\u0644\u0627\u062a \u0627\u0644\u062a\u0649 \u062a\u062d\u062f\u062b \u0645\u0639 \u0646\u0633\u062e\u0629 \u0627\u0644 32 \u0628\u062a.<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u064a\u0645\u0643\u0646\u0643 \u0632\u064a\u0627\u062f\u0629 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629 \u0645\u0639 \u0646\u0633\u062e\u0629 32 \u0628\u062a \u0644\u0623\u0643\u062b\u0631 \u0645\u0646 3 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a\u00a0 \u0648\u0630\u0644\u0643 \u0639\u0646 \u0637\u0631\u064a\u0642 \u0627\u0636\u0627\u0641\u0629 \u0627\u0644\u0645\u0641\u062a\u0627\u062d \/3GB \u0644\u0645\u0644\u0641 \u0627\u0644 boot.ini \u0639\u0644\u0649 \u0627\u0644\u0648\u0646\u062f\u0648\u0632 \u0648\u0627\u0644\u0630\u0649 \u0633\u064a\u0643\u0648\u0646 \u0634\u0643\u0644\u0647 \u0643\u0627\u0644\u062a\u0627\u0644\u0649 \u0628\u0639\u0636 \u0627\u0644\u062a\u0639\u062f\u064a\u0644 \u00a0multi(0)disk(0)rdisk(0)partition(1)\\WINNT=&#8221;Microsoft Windows 2000 Advanced Server&#8221; \/fastdetect \/3GB<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0627\u062f\u0627\u0647 perfmon \u0644\u0645\u0631\u0627\u0642\u0628\u0629 \u0627\u062f\u0627\u0621 \u0627\u0648\u0631\u0627\u0643\u0644 Oracle.exe<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0627\u0630\u0627 \u0627\u0635\u064a\u062d\u062a \u0642\u064a\u0645\u0629 Total Pool Non-Paged Bytes \u0627\u0642\u0631\u0628 \u0628\u0639\u062f\u062f\u0627 \u0627\u0644\u0645\u0631\u0627\u0642\u0628\u0629 \u0627\u0644\u0649 \u0627\u0644\u0642\u064a\u0645\u0629 128 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0641\u0647\u0646\u0627\u0643 \u0627\u062d\u062a\u0645\u0627\u0644 \u0643\u0628\u064a\u0631 \u0644\u0638\u0647\u0648\u0631 \u0645\u0634\u0643\u0644\u0629 \u0628\u0646\u0638\u0627\u0645 \u0627\u0644\u062a\u0634\u063a\u064a\u0644 .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u064a\u062c\u0628 \u0627\u0646 \u0644\u0627\u062a\u0642\u0644 \u0642\u064a\u0645\u0629 Free System Page Table Entries (PTE\u2019s) \u0639\u0646 7500\u00a0 \u0648\u0627\u0630\u0627 \u062d\u062f\u062b \u064a\u062c\u0628 \u0627\u0630\u0627\u0641\u0629 \u0627\u0644\u0645\u0641\u062a\u0627\u062d\u00a0 \/USERVA=2560\u00a0 \u0627\u0644\u0649 \u0645\u0644\u0641 \u0627\u0644 boot.ini<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0646\u0633\u062e\u0629 \u0648\u0646\u062f\u0648\u0632 \u0633\u064a\u0631\u0641\u0631 32\u0628\u062a standard \u062a\u062f\u0639\u0645 \u062d\u062a\u0649 4 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a\u00a0 \u0648\u0646\u0633\u062e\u0629 \u0633\u064a\u0631\u0641\u0631 32 \u0628\u062a Enterprise \u062a\u062f\u0639\u0645 \u062d\u062a\u0649 32 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0648\u0646\u0633\u062e\u0629 \u0633\u064a\u0631\u0641\u0631 \u00a032 \u0628\u062a Datacenter \u062a\u062f\u0639\u0645 \u062d\u062a\u0649 64 \u062c\u0627\u062c\u0627\u0628\u0627\u064a\u062a .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 AWE \u0644\u0631\u0641\u0639 \u0642\u064a\u0645\u0629 database buffer \u062d\u062a\u0649 12 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a\u00a0 \u0648\u0644\u0639\u0645\u0644 \u0630\u0644\u0643 \u064a\u062c\u0628 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u0627\u062f\u0627\u0647\u00a0 \u0627\u0644\u0642\u064a\u0645\u0629 USE_INDIRECT_DATA_BUFFERS\u00a0 \u0643\u0645\u0627 \u064a\u062c\u0628 \u0639\u0646\u062f\u0647\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644\u00a0 DB_BLOCK_BUFFERS \u0628\u062f\u0644\u0627 \u0639\u0646 DATABASE_CACHE_SIZE<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062e\u0627\u0635\u064a\u0629 Automatic workload Repository \u0644\u0645\u0631\u0627\u0642\u0628\u0629 \u0627\u0644 Cache ratio \u0648\u0627\u0644 shared pool<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0627\u0644\u062e\u0627\u0635\u064a\u0629 AWE \u0648 AWR \u0644\u0646 \u062a\u0639\u0645\u0644 \u0645\u0639\u0647\u0645\u0627 \u062e\u0627\u0635\u064a\u0629 Automatic Memory Management \u00a0\u0644\u0630\u0627 \u064a\u062c\u0628 \u0648\u0636\u0639 \u0630\u0644\u0643 \u0641\u0649 \u0627\u0644\u062d\u0633\u0628\u0627\u0646 .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a 64\u0628\u062a \u0639\u0644\u0649 \u0627\u0644\u0633\u064a\u0631\u0641\u0631 \u0648\u062a\u0643\u0648\u0646 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a 32\u0628\u062a \u062f\u0648\u0646 \u0645\u0634\u0643\u0644\u0627\u062a .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0645\u0644\u0641\u0627\u062a \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a Datafiles \u00a0\u0627\u0648\u0631\u0627\u0643\u0644 32\u0628\u062a \u0645\u062a\u0648\u0627\u0641\u0642\u0629 \u0645\u0639 \u0646\u0633\u062e\u0629 64\u0628\u062a .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0646\u0633\u062e\u0629 \u0623\u0648\u0631\u0627\u0643\u0644 \u0627\u0644\u0645\u062e\u0635\u0635\u0629 \u0644 32\u0628\u062a \u063a\u064a\u0631 \u0645\u062f\u0639\u0648\u0645\u0629 \u0639\u0644\u0649 \u0627\u0646\u0638\u0645\u0629 64\u0628\u062a .<\/p>\n<p dir=\"RTL\">&#8211;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0627\u0630\u0627 \u0643\u0646\u062a \u0633\u062a\u0633\u062e\u062f\u0645 \u0646\u0633\u062e\u0629 \u0648\u0646\u062f\u0648\u0632 2003 \u0641\u064a\u062c\u0628 \u0639\u0644\u064a\u0643 \u0627\u0644\u0627\u0646\u062a\u0642\u0627\u0644 \u0627\u0644\u0649 sp2 \u0639\u0644\u0649 \u0627\u0644\u0627\u0642\u0644 \u0644\u062a\u0644\u0627\u0641\u0649 \u0645\u0634\u0643\u0644\u0627\u062a \u062a\u062e\u0635 \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0648 \u0627\u0644\u0627\u0641\u0636\u0644 \u0627\u0644\u0627\u0646\u062a\u0642\u0627\u0644 \u0627\u0644\u0649 \u0627\u0644\u0646\u0633\u062e\u0629 \u0648\u0646\u062f\u0648\u0632 2008 .<\/p>\n<p>\u00a0\u062a\u062d\u064a\u0627\u062a\u0649<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0633\u0644\u0627\u0645 \u0627\u0644\u0646\u0642\u0627\u0637 \u0627\u0644\u062a\u0627\u0644\u064a\u0629 \u062a\u0639\u062a\u0628\u0631 \u0627\u0633\u0627\u0633 \u0644\u062a\u062d\u0633\u064a\u0646 \u0627\u062f\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648\u0631\u0627\u0643\u0644 , \u062d\u0627\u0648\u0644\u062a \u0627\u0644\u0623\u062e\u062a\u0635\u0627\u0631 \u0628\u0642\u062f\u0631 \u0627\u0644\u0625\u0645\u0643\u0627\u0646 \u0645\u0647\u0627\u0631\u0627\u062a \u0648\u0623\u0633\u0627\u0633\u064a\u0627\u062a \u062a\u062d\u0633\u064a\u0646 \u0627\u062f\u0627\u0621 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a : \u0627\u0648\u0644\u0627 \u0627\u0644\u0623\u0635\u062f\u0627\u0631\u0627\u062a \u0639\u0644\u0649 \u0645\u0639\u0645\u0627\u0631\u064a\u0629 32 \u0628\u062a OS 10gR2 11gR1 11gR2 Windows XP Professional Yes Yes Yes Windows Server 2003 and Windows Server 2003 R2 Yes Yes Yes Windows Vista 10.2.0.4 Yes Yes Windows [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[138,139],"class_list":["post-561","post","type-post","status-publish","format-standard","hentry","category--adf","tag-138","tag-139"],"views":5146,"_links":{"self":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts\/561","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=561"}],"version-history":[{"count":14,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts\/561\/revisions"}],"predecessor-version":[{"id":642,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=\/wp\/v2\/posts\/561\/revisions\/642"}],"wp:attachment":[{"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qdatabyte.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}