èíòåðåñíî è êàê ìîæíî èñïîëüçîâàòü 2,5 ãèãà åñëè ÷àñòü îïåðàòèâêè íóæíà âèíäå è ñëóæåáíûì ñåðâèñàì.

èñòîðèÿ ñ ñàìîãî íà÷àëà òàêàÿ, ÿ äîáàâèë ê 1.5Gb ïàìÿòè åùå 1 .5Gb è óâåëè÷èë ïàðàìåòð sort_area_size äî 4 Mb. Ïîñëå ýòîãî ïîÿâèëàñü îøèáêà ORA-03232, îò íåå ÿ èçáàâèëñÿ óâåëè÷åíèåì ïàðàìåòðà NEXT äî 1Mb ó âðåìåííåãî òàáëè÷íîãî ïðîñòðàíñòâà.
Ïîñëå ýòîãî ïðèìåðíî ïîëäíÿ áàçà ïðîðàáîòàëà íîðìàëüíî, íî ïîòîì ïîëåçëà îøèáêà ORA-04030.
Åñòü ëè êîêîé íèáóäü àëãîðèòì ïî áîëåå ïîëíîìó èñïîëüçîâàíèþ îïåðàòèâíîé ïàìÿòè ?

&iacute;&agrave;&auml;&icirc; &iuml;&icirc;&ntilde;&divide;&egrave;&ograve;&agrave;&ograve;&uuml; &iuml;&icirc; &ograve;&aring;&ecirc;&oacute;&ugrave;&egrave;&igrave; &iuml;&agrave;&eth;&agrave;&igrave;&aring;&ograve;&eth;&agrave;&igrave; &ntilde;&ecirc;&icirc;&euml;&uuml;&ecirc;&icirc; &iuml;&agrave;&igrave;&yuml;&ograve;&egrave; &ccedil;&agrave;&eacute;&igrave;&aring;&ograve; &icirc;&eth;&agrave;&ecirc;&euml; &iuml;&eth;&egrave; &igrave;&agrave;&ecirc;&ntilde;&egrave;&igrave;&oacute;&igrave;&aring; &iacute;&agrave;&atilde;&eth;&oacute;&ccedil;&ecirc;&egrave; &egrave; &aring;&ntilde;&euml;&egrave; &iuml;&icirc;&euml;&oacute;&divide;&aring;&iacute;&iacute;&agrave;&yuml; &ouml;&egrave;&ocirc;&eth;&agrave; &iuml;&icirc;&igrave;&aring;&ugrave;&agrave;&aring;&ograve;&ntilde;&yuml; &acirc; 70 &iuml;&eth;&icirc;&ouml;&aring;&iacute;&ograve;&icirc;&acirc; &icirc;&ograve; &auml;&icirc;&ntilde;&ograve;&oacute;&iuml;&iacute;&icirc;&eacute; &icirc;&iuml;&aring;&eth;&agrave;&ograve;&egrave;&acirc;&iacute;&icirc;&eacute; &iuml;&agrave;&igrave;&yuml;&ograve;&egrave;, &ograve;&icirc; &acirc;&ntilde;&aring; &icirc;&ecirc;.<br><br>Сообщение отредактировано: mit, в: 2005/05/03 10:31

&auml;&icirc; &oacute;&acirc;&aring;&euml;&egrave;&divide;&aring;&iacute;&egrave;&yuml; &iuml;&agrave;&igrave;&yuml;&ograve;&egrave; &ntilde; 1.5 &iacute;&agrave; 2.5 Gb &iuml;&agrave;&igrave;&yuml;&ograve;&uuml; &acirc;&ntilde;&yuml; &auml;&icirc;&ntilde;&ograve;&oacute;&iuml;&iacute;&agrave;&yuml; &iuml;&agrave;&igrave;&yuml;&ograve;&uuml; &egrave;&ntilde;&divide;&aring;&eth;&iuml;&ucirc;&acirc;&agrave;&euml;&agrave;&ntilde;&uuml;, &egrave; &auml;&agrave;&aelig;&aring; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&euml;&ntilde;&yuml; &ocirc;&agrave;&eacute;&euml; &iuml;&icirc;&auml;&ecirc;&agrave;&divide;&ecirc;&egrave;. &Agrave; &ntilde; &ograve;&aring;&otilde; &iuml;&icirc;&eth; &igrave;&aring;&iacute;&yuml;&euml;&ntilde;&yuml; &ograve;&icirc;&euml;&uuml;&ecirc;&icirc; &acirc;&aring;&euml;&egrave;&divide;&egrave;&iacute;&agrave; sort_area_size &egrave; &iuml;&agrave;&eth;&agrave;&igrave;&aring;&ograve; NEXT &acirc;&eth;&aring;&igrave;&aring;&iacute;&iacute;&icirc;&atilde;&icirc; &ograve;&agrave;&aacute;&euml;&egrave;&divide;&iacute;&icirc;&atilde;&icirc; &iuml;&eth;&icirc;&ntilde;&ograve;&eth;&agrave;&iacute;&ntilde;&ograve;&acirc;&agrave;.
&Oacute; &igrave;&aring;&iacute;&yuml; &aring;&ntilde;&ograve;&uuml; &iacute;&aring;&igrave;&iacute;&icirc;&atilde;&icirc; &auml;&eth;&oacute;&atilde;&icirc;&eacute; &acirc;&icirc;&iuml;&eth;&icirc;&ntilde; : &ecirc;&agrave;&ecirc; &igrave;&icirc;&aelig;&iacute;&icirc; &aacute;&ucirc;&ntilde;&ograve;&eth;&icirc; &acirc;&ucirc;&yuml;&ntilde;&iacute;&egrave;&ograve;&uuml; &divide;&ograve;&icirc; &icirc;&eth;&agrave;&ecirc;&euml; &igrave;&icirc;&aelig;&aring;&ograve; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&ograve;&uuml; &iuml;&agrave;&igrave;&yuml;&ograve;&uuml; &ntilde;&acirc;&ucirc;&oslash;&aring; 2 Gb ?

&ecirc;&agrave;&ecirc; &yuml; &iuml;&icirc;&iacute;&yuml;&euml; &icirc;&ograve;&ntilde;&thorn;&auml;&agrave; http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ddtools/hh/ddtools/BootIni_de16d3ec-c437-4628-805f-8945ea598a92.xml.asp
&icirc;&eth;&agrave;&ecirc;&euml; &igrave;&icirc;&aelig;&aring;&ograve; &thorn;&ccedil;&agrave;&ograve;&uuml; &ograve;&icirc;&euml;&uuml;&ecirc;&icirc; 2Gb &aacute;&aring;&ccedil; &ecirc;&euml;&thorn;&divide;&agrave; &egrave; 3 Gb c &ecirc;&euml;&thorn;&divide;&icirc;&igrave; &acirc; boot.ini. &Auml;&agrave;&euml;&aring;&aring; &ntilde; &iuml;&icirc;&igrave;&icirc;&ugrave;&uuml;&thorn; PAE/AVE &igrave;&icirc;&aelig;&iacute;&icirc; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&ograve;&uuml; &ntilde;&acirc;&ucirc;&oslash;&aring; 3Gb, &ograve;&icirc;&euml;&uuml;&ecirc;&icirc; &aring;&ntilde;&euml;&egrave; &oacute; &acirc;&agrave;&ntilde; &iacute;&agrave; &ntilde;&aring;&eth;&acirc;&aring;&eth;&aring; 4 &atilde;&egrave;&atilde;&agrave; &iuml;&agrave;&igrave;&yuml;&ograve;&egrave;.
&ETH;&aring;&ccedil;&thorn;&igrave;&aring;: &iacute;&agrave; &Acirc;&agrave;&oslash;&aring;&eacute; &acirc;&aring;&eth;&ntilde;&egrave;&egrave; &acirc;&egrave;&iacute;&auml;&ucirc; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&ograve;&uuml; &aacute;&icirc;&euml;&uuml;&oslash;&aring; 2 &atilde;&egrave;&atilde;&icirc;&acirc; &iacute;&aring; &iuml;&icirc;&euml;&oacute;&divide;&egrave;&ograve;&ntilde;&yuml;.