äà êàæäûé ïîëüçîâàòåëü èäåò çà äâîèõ, òå Ïàðóñ îòêðûâàåò äâå ñåññèè: ñàìîãî ìîäóëÿ è êðèñòàëà.

êàê óçíàòü â êàêîì ðåæèìå ðàáîòàåò ñåðâåð:
ìîæíî ïîñìîòðåòü â ïàðàìåòðû Init.ora èëè òàê
â sql plus: show parameter mts_
Åñëè mts_servers, mts_sessions, mts_dispatchers = 0 (èëè NULL), òî ñåðâåð â ðåæèìå dedicated.
Åñëè íåò - shared + âîçìîæíû îòäåëüíûå ïîäêëþ÷åíèÿ â ðåæèìå dedicated (íóæíî ñìîòðåòü tnsnames.ora íà êëèåíò&aring

Âçÿòî îòñþäà: http://www.sql.ru/forum/actualthread.aspx?tid=116437&hl=mts+dedicated

Mit ïèñàë(&agrave:

Цитата:
äà êàæäûé ïîëüçîâàòåëü èäåò çà äâîèõ, òå Ïàðóñ îòêðûâàåò äâå ñåññèè: ñàìîãî ìîäóëÿ è êðèñòàëà.

Òåïåðü ïîíÿòíî.
Ñóäÿ ïî ïàðàìåòðàì mts_, ñåðâåð dedicated.
Íî íåïîíÿòíî, ïî÷åìó ïàìÿòü ñòàëà èñïîëüçîâàòüñÿ àêòèâíåå ïîñëå óäàëåíèÿ õèíòîâ.

&Agrave; &aring;&ntilde;&euml;&egrave; &eth;&agrave;&aacute;&icirc;&ograve;&agrave;&ograve;&uuml; &acirc; &Iuml;&Agrave;&ETH;&Oacute;&Ntilde;&aring;, &iacute;&aring; &ccedil;&agrave;&iuml;&oacute;&ntilde;&ecirc;&agrave;&yuml; &icirc;&ograve;&divide;&cedil;&ograve;&icirc;&acirc;, &acirc;&ntilde;&cedil; &eth;&agrave;&acirc;&iacute;&icirc; &ntilde;&aring;&ntilde;&ntilde;&egrave;&thorn; &auml;&euml;&yuml; &ecirc;&eth;&egrave;&ntilde;&ograve;&agrave;&euml;&agrave; &icirc;&ograve;&ecirc;&eth;&icirc;&aring;&ograve;?<br><br>Сообщение отредактировано: Alexander, в: 2004/12/22 14:12

&iuml;&icirc;&ograve;&icirc;&igrave;&oacute; &divide;&ograve;&icirc; sort_area_size * 2 &yacute;&ograve;&icirc; HASH_AREA_SIZE &ecirc;&icirc;&ograve;&icirc;&eth;&ucirc;&eacute; &igrave;&icirc;&aelig;&iacute;&icirc; &oacute;&ntilde;&ograve;&agrave;&iacute;&icirc;&acirc;&egrave;&ograve;&uuml; &euml;&egrave;&aacute;&icirc; &acirc;&eth;&oacute;&divide;&iacute;&oacute;&thorn; &acirc; &egrave;&iacute;&egrave;&ograve;.&icirc;&eth;&agrave; &euml;&egrave;&aacute;&icirc; &iacute;&aring; &oacute;&ecirc;&agrave;&ccedil;&ucirc;&acirc;&agrave;&ograve;&uuml; &egrave; &ograve;&icirc;&atilde;&auml;&agrave; &iuml;&icirc; &oacute;&igrave;&icirc;&euml;&divide;&agrave;&iacute;&egrave;&thorn; &auml;&agrave;&iacute;&iacute;&icirc;&aring; &ccedil;&iacute;&agrave;&divide;&aring;&iacute;&egrave;&aring; &aacute;&oacute;&auml;&aring;&ograve; &eth;&agrave;&acirc;&iacute;&icirc; sort_area_size * 2. &Iacute;&icirc; &auml;&agrave;&iacute;&iacute;&agrave;&yuml; &iuml;&agrave;&igrave;&yuml;&ograve;&uuml; &aacute;&oacute;&auml;&aring;&ograve; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&ograve;&uuml;&ntilde;&yuml; &ograve;&icirc;&euml;&uuml;&ecirc;&icirc; &iuml;&eth;&egrave; hash joins &acirc; &ntilde;&aring;&euml;&aring;&ecirc;&ograve;&agrave;&otilde;. &Iuml;&eth;&aring;&auml;&acirc;&icirc;&ntilde;&otilde;&egrave;&ugrave;&agrave;&yuml; &acirc;&icirc;&iuml;&eth;&icirc;&ntilde; &agrave; &divide;&ograve;&icirc; &aring;&ntilde;&ograve;&uuml; hash join &eth;&aring;&ecirc;&icirc;&igrave;&aring;&iacute;&auml;&oacute;&thorn; &icirc;&aacute;&eth;&agrave;&ograve;&egrave;&ograve;&ntilde;&yuml; &ecirc; &yuml;&iacute;&auml;&aring;&ecirc;&ntilde;&oacute;. &Iuml;&icirc;&euml;&iacute;&icirc; &auml;&icirc;&ecirc;&oacute;&igrave;&aring;&iacute;&ograve;&agrave;&ouml;&egrave;&egrave; &ecirc;&agrave;&ecirc; &iacute;&agrave; &eth;&oacute;&ntilde;&ntilde;&ecirc;&icirc;&igrave; &ograve;&agrave;&ecirc; &egrave; &iacute;&agrave; &agrave;&iacute;&atilde;&euml;&egrave;&eacute;&ntilde;&ecirc;&icirc;&igrave; &yuml;&ccedil;&ucirc;&ecirc;&aring;. &Ecirc;&eth;&agrave;&ograve;&ecirc;&icirc; &yacute;&ograve;&icirc; &eth;&agrave;&ccedil;&euml;&egrave;&divide;&iacute;&ucirc;&aring; &ntilde;&iuml;&icirc;&ntilde;&icirc;&aacute;&ucirc; &ntilde;&icirc;&aring;&auml;&egrave;&iacute;&aring;&iacute;&egrave;&yuml; &ograve;&agrave;&aacute;&euml;&egrave;&ouml;, &ecirc;&icirc;&ograve;&icirc;&eth;&ucirc;&aring; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&oacute;&aring;&ograve; &icirc;&eth;&agrave;&ecirc;&euml;. &Iuml;&icirc;&divide;&egrave;&ograve;&agrave;&ograve;&uuml; &igrave;&icirc;&aelig;&iacute;&icirc; &iacute;&agrave;&iuml;&eth;&egrave;&igrave;&aring;&eth; &ccedil;&auml;&aring;&ntilde;&uuml;: http://www.ixora.com.au/q+a/sqlopt.htm &ETH;&aring;&ccedil;&thorn;&igrave;&egrave;&eth;&oacute;&yuml;: &iuml;&agrave;&igrave;&yuml;&ograve;&egrave; &ntilde;&ograve;&agrave;&euml;&icirc; &ccedil;&agrave;&aacute;&egrave;&eth;&agrave;&ograve;&uuml;&ntilde;&yuml; &aacute;&icirc;&euml;&uuml;&oslash;&aring; &iuml;&icirc;&ograve;&icirc;&igrave;&oacute; &ecirc;&agrave;&ecirc; &iuml;&icirc;&yuml;&acirc;&egrave;&euml;&icirc;&ntilde;&uuml; &aacute;&icirc;&euml;&uuml;&oslash;&aring; hash join.

P.S. &Ecirc;&ntilde;&ograve;&agrave;&ograve;&egrave; &icirc;&eth;&agrave;&ecirc;&euml; &iacute;&aring; &eth;&aring;&ecirc;&icirc;&igrave;&aring;&iacute;&auml;&oacute;&aring;&ograve; &oacute;&ntilde;&ograve;&agrave;&iacute;&agrave;&acirc;&euml;&egrave;&acirc;&agrave;&ograve;&uuml; &auml;&agrave;&iacute;&iacute;&ucirc;&eacute; &iuml;&agrave;&eth;&agrave;&igrave;&aring;&ograve;&eth; &yuml;&acirc;&iacute;&icirc; &acirc; &egrave;&iacute;&egrave;&ograve;.&icirc;&eth;&agrave;.

&Auml;&icirc;&atilde;&agrave;&auml;&ucirc;&acirc;&agrave;&thorn;&ntilde;&uuml;, &divide;&ograve;&icirc; &ntilde; hash_joins &yacute;&ograve;&icirc; &euml;&oacute;&divide;&oslash;&aring;, &divide;&aring;&igrave; &aacute;&aring;&ccedil; &iacute;&egrave;&otilde;. &ETH;&agrave;&aacute;&icirc;&ograve;&aring;&ograve;-&ograve;&icirc; &eth;&aring;&agrave;&euml;&uuml;&iacute;&icirc; &aacute;&ucirc;&ntilde;&ograve;&eth;&aring;&aring;.

&aring;&ntilde;&ograve;&uuml; &aring;&ugrave;&aring; &auml;&eth;&oacute;&atilde;&icirc;&eacute; &iuml;&icirc;&auml;&icirc;&aacute;&iacute;&ucirc;&eacute; &atilde;&euml;&thorn;&ecirc; &ntilde;&igrave;. &ograve;&aring;&igrave;&oacute; &eth;&agrave;&ccedil;&auml;&aring;&euml;&aring; pl &egrave; pl/sql &auml;&agrave;&iacute;&iacute;&icirc;&atilde;&icirc; &ocirc;&icirc;&eth;&oacute;&igrave;&agrave;.