È íà äóøå êàê-òî ñòàëî ëåã÷å ñðàçó...

Íà÷àëîñü âñ¸ â÷åðà ñ òîãî, ÷òî ýëåìåíòàðíûé çàïðîñ â íåèìåíîâàíîì áëîêå, ïðèâÿçàíîì ê ñîçäàíèþ ôàêòóðû èç íàêëàäíîé (áëîê èñïðàâëÿë äàòó ôàêòóð&ucirc íà÷àë äåëàòü FULL SCAN TABLE, FULL SCAN INDEX, ãèãàáàéòíûé SORT....

Код:

select NOUT_DOCUMENT into nFAKT_RN from V_DOCLINKS_INOUT_OUT where NDOCUMENT = nNAKL_RN and SUNITCODE = 'GoodsTransInvoicesToConsumers' and SOUT_UNITCODE = 'AccountFactOutput';

&Igrave;&oacute;&divide;&agrave;&euml;&egrave;&ntilde;&uuml; &acirc;&aring;&ntilde;&uuml; &auml;&aring;&iacute;&uuml;, &iacute;&icirc; &eth;&agrave;&aacute;&icirc;&ograve;&agrave;&euml;&icirc; (&ntilde; &ccedil;&agrave;&auml;&aring;&eth;&aelig;&ecirc;&icirc;&eacute; &icirc;&ograve; 5 &auml;&icirc; 10 &igrave;&egrave;&iacute;&oacute;&ograve; &iacute;&agrave; &icirc;&auml;&iacute;&icirc; &ntilde;&icirc;&ccedil;&auml;&agrave;&iacute;&egrave;&aring; &ocirc;&agrave;&ecirc;&ograve;&oacute;&eth;&ucirc &Iuml;&icirc;&oacute;&aacute;&egrave;&eth;&agrave;&euml; &otilde;&egrave;&iacute;&ograve;&ucirc; &egrave;&ccedil; V_DOCLINKS_INOUT_OUT, V_DOCLINKS_INOUT_IN, V_PAYACC, V_DICACCFO, V_TRANSINVCUST &egrave; &ograve;.&auml;. &ntilde;&ograve;&agrave;&euml;&icirc; &quot;&oslash;&oacute;&eth;&oslash;&agrave;&ograve;&uuml;&quot; &ccedil;&agrave; &auml;&icirc;&euml;&egrave; &ntilde;&aring;&ecirc;&oacute;&iacute;&auml;&ucirc;. &iacute;&oacute; &yuml; &egrave; &iuml;&icirc;&atilde;&eth;&icirc;&otilde;&agrave;&euml; &acirc;&ntilde;&aring; &otilde;&egrave;&iacute;&ograve;&ucirc; &acirc;&icirc; &acirc;&ntilde;&aring;&otilde; &acirc;&uuml;&thorn;&otilde;&agrave;&otilde;. &igrave;&icirc;&aelig;&aring;&ograve; &atilde;&auml;&aring;-&ograve;&icirc; &egrave; &iacute;&aring; &ntilde;&icirc;&acirc;&ntilde;&aring;&igrave; &iuml;&eth;&agrave;&acirc;&egrave;&euml;&uuml;&iacute;&icirc;, &iacute;&icirc; &ograve;&agrave;&ecirc;&egrave;&otilde; &ntilde;&ograve;&eth;&agrave;&oslash;&iacute;&ucirc;&otilde; &atilde;&euml;&thorn;&ecirc;&icirc;&acirc; &ograve;&icirc;&divide;&iacute;&icirc; &iacute;&aring; &aacute;&oacute;&auml;&aring;&ograve;. &Egrave; &ecirc;&ograve;&icirc; &iuml;&eth;&egrave;&auml;&oacute;&igrave;&agrave;&euml; &acirc;&ntilde;&ograve;&agrave;&acirc;&euml;&yuml;&ograve;&uuml; &acirc;&aring;&ccedil;&auml;&aring; &yacute;&ograve;&icirc; /*+RULE*/ ????? <br><br>Сообщение отредактировано: Alexander, в: 2004/12/21 12:54

&yuml; &aelig;&aring; &oacute;&aelig;&aring; &icirc;&ograve;&acirc;&aring;&divide;&agrave;&euml; &iuml;&eth;&icirc; &ecirc;&ograve;&icirc; &iuml;&eth;&egrave;&auml;&oacute;&igrave;&agrave;&euml; &acirc;&ntilde;&ograve;&agrave;&acirc;&euml;&yuml;&ograve;&uuml; &otilde;&egrave;&iacute;&ograve;&ucirc; &acirc;&icirc; &acirc;&uuml;&thorn;&otilde;&agrave;&otilde;: &iuml;&agrave;&eth;&oacute;&ntilde; &iacute;&agrave;&divide;&egrave;&iacute;&agrave;&euml;&ntilde;&yuml; &ntilde; 7-&eacute; &acirc;&aring;&eth;&ntilde;&egrave;&egrave; &Icirc;&eth;&agrave;&ecirc;&euml;&agrave; &acirc; &ecirc;&icirc;&ograve;&icirc;&eth;&icirc;&igrave; CBO &eth;&agrave;&aacute;&icirc;&ograve;&agrave;&euml; &iacute;&aring;&ntilde;&ograve;&agrave;&aacute;&egrave;&euml;&uuml;&iacute;&icirc; &egrave; &iuml;&icirc;&ograve;&icirc;&igrave;&oacute; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&euml;&ntilde;&yuml; RBO &iuml;&oacute;&ograve;&aring;&igrave; &oacute;&ntilde;&ograve;&agrave;&iacute;&icirc;&acirc;&ecirc;&egrave; &iuml;&agrave;&eth;&agrave;&igrave;&aring;&ograve;&eth;&agrave; &acirc; init.ora &euml;&egrave;&aacute;&icirc; &egrave;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&iacute;&egrave;&aring;&igrave; &otilde;&egrave;&iacute;&ograve;&agrave; RULE &acirc; &ccedil;&agrave;&iuml;&eth;&icirc;&ntilde;&agrave;&otilde;.

&szlig; &icirc;&ograve;&ecirc;&euml;&thorn;&divide;&egrave;&euml; &acirc;&icirc;&icirc;&aacute;&ugrave;&aring; &acirc;&ntilde;&aring; &otilde;&egrave;&iacute;&ograve;&ucirc;, &egrave; ORDERER &egrave; INDEX &egrave; ALL_ROWS &aacute;&ucirc;&euml;&icirc;.
&Iuml;&icirc;&ograve;&icirc;&igrave;&oacute; &divide;&ograve;&icirc; &acirc; V_DOCLINKS_INOUT_OUT &ntilde;&ograve;&icirc;&yuml;&euml; &otilde;&egrave;&iacute;&ograve; ORDERER &egrave; &icirc;&iacute; &igrave;&iacute;&aring; &iacute;&agrave; &iuml;&eth;&icirc;&ntilde;&ograve;&aring;&iacute;&uuml;&ecirc;&icirc;&igrave; &ccedil;&agrave;&iuml;&eth;&icirc;&ntilde;&aring; &auml;&aring;&euml;&agrave;&euml; &aacute;&eth;&aring;&auml;.
&szlig; &oacute;&auml;&agrave;&euml;&egrave;&euml; &otilde;&egrave;&iacute;&ograve; ORDERER &egrave;&ccedil; V_DOCLINKS_INOUT_OUT, &ccedil;&agrave;&iuml;&eth;&icirc;&ntilde; &ntilde;&ograve;&agrave;&euml; &icirc;&aacute;&eth;&agrave;&aacute;&agrave;&ograve;&ucirc;&acirc;&agrave;&ograve;&uuml;&ntilde;&yuml; &igrave;&atilde;&iacute;&icirc;&acirc;&aring;&iacute;&iacute;&icirc;, &Iacute;&Icirc; &iuml;&icirc;&yuml;&acirc;&egrave;&euml;&egrave;&ntilde;&uuml; &ograve;&icirc;&eth;&igrave;&icirc;&ccedil;&agrave; &iuml;&eth;&egrave; &iuml;&aring;&eth;&aring;&otilde;&icirc;&auml;&aring; &iuml;&icirc; &ntilde;&acirc;&yuml;&ccedil;&yuml;&igrave;, &iacute;&agrave;&iuml;&eth;&egrave;&igrave;&aring;&eth; &egrave;&ccedil; &ocirc;&agrave;&ecirc;&ograve;&oacute;&eth;&ucirc; &acirc; &iacute;&agrave;&ecirc;&euml;&agrave;&auml;&iacute;&oacute;&thorn;.
&Iacute;&oacute; &yuml; &iacute;&agrave;&divide;&agrave;&euml; &oacute;&auml;&agrave;&euml;&yuml;&ograve;&uuml; &euml;&thorn;&aacute;&ucirc;&aring; &acirc;&ntilde;&aring; &ecirc;&agrave;&ecirc;&egrave;&aring; &oacute;&acirc;&egrave;&auml;&aring;&euml; &otilde;&egrave;&iacute;&ograve;&ucirc; &acirc; V_TRANSINVCUST, V_DICACCFO, V_PAYACC, &iuml;&aring;&eth;&aring;&otilde;&icirc;&auml;&ucirc; &iuml;&icirc; &ntilde;&acirc;&yuml;&ccedil;&yuml;&igrave; &ograve;&icirc;&aelig;&aring; &ntilde;&ograve;&agrave;&euml;&egrave; &aacute;&ucirc;&ntilde;&ograve;&eth;&ucirc;&aring;.
&Acirc;&icirc;&ograve; &ograve;&agrave;&ecirc;&egrave;&aring; &auml;&aring;&euml;&agrave;.<br><br>Сообщение отредактировано: Alexander, в: 2004/12/21 15:57

&Iuml;&agrave;&igrave;&yuml;&ograve;&uuml; &ntilde;&ograve;&agrave;&euml;&icirc; &icirc;&ograve;&aelig;&egrave;&eth;&agrave;&ograve;&uuml;, &icirc;&auml;&iacute;&agrave;&ecirc;&icirc;...

&Auml;&icirc; &oacute;&aacute;&egrave;&eth;&agrave;&iacute;&egrave;&yuml; &otilde;&egrave;&iacute;&ograve;&icirc;&acirc; &aacute;&ucirc;&euml;&icirc; &ograve;&agrave;&ecirc;:

shared_pool 512Mb
buffers 384Mb
java 64Mb
log_buffer 64Mb
sort_area 16Mb

&Iuml;&euml;&agrave;&iacute;&ecirc;&agrave; &egrave;&ntilde;&iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&iacute;&egrave;&yuml; &iuml;&agrave;&igrave;&yuml;&ograve;&egrave; &auml;&icirc; 2.4...2.5 &Atilde;&aacute;

&Ograve;&aring;&iuml;&aring;&eth;&uuml; &ograve;&agrave;&ecirc;:

shared_pool 384Mb
buffers 256Mb
java 64Mb
log_buffer 64Mb
sort_area 10Mb

&Egrave; &icirc;&ograve;&uacute;&aring;&euml;&icirc; &oacute;&aelig;&aring; &acirc;&ntilde;&aring; &auml;&icirc;&ntilde;&ograve;&oacute;&iuml;&iacute;&ucirc;&otilde; 3 &Atilde;&egrave;&atilde;&agrave; &iuml;&icirc;&divide;&ograve;&egrave;... &acirc;&icirc; &auml;&aring;&euml;&agrave;!
&Iuml;&eth;&agrave;&acirc;&auml;&agrave;, &Iuml;&Agrave;&ETH;&Oacute;&Ntilde; &iuml;&eth;&egrave; &acirc;&ntilde;&cedil;&igrave; &iuml;&eth;&egrave; &yacute;&ograve;&icirc;&igrave; &eth;&agrave;&aacute;&icirc;&ograve;&agrave;&aring;&ograve; &ccedil;&iacute;&agrave;&divide;&egrave;&ograve;&aring;&euml;&uuml;&iacute;&icirc; &acirc;&aring;&ntilde;&aring;&euml;&aring;&aring;, &divide;&aring;&igrave; &eth;&agrave;&iacute;&uuml;&oslash;&aring;.

&ecirc;&agrave;&ecirc; &iuml;&icirc;&auml;&ntilde;&divide;&egrave;&ograve;&agrave;&ograve;&uuml; &iuml;&eth;&egrave;&igrave;&aring;&eth;&iacute;&icirc;&aring; &ccedil;&iacute;&agrave;&divide;&aring;&iacute;&egrave;&aring; &ccedil;&agrave;&iacute;&egrave;&igrave;&agrave;&aring;&igrave;&icirc;&eacute; &icirc;&eth;&agrave;&ecirc;&euml;&icirc;&igrave; &iuml;&agrave;&igrave;&yuml;&ograve;&egrave; &yuml; &iuml;&egrave;&ntilde;&agrave;&euml; &ccedil;&auml;&aring;&ntilde;&uuml; http://www.sql.ru/forum/actualthread.aspx?tid=77742&amp;hl=mit

&Agrave; &ecirc;&agrave;&ecirc; &oacute;&ccedil;&iacute;&agrave;&ograve;&uuml;, &ntilde;&aring;&eth;&acirc;&aring;&eth; dedicated &egrave;&euml;&egrave; &iacute;&aring; dedicated?

&Iuml;&icirc; &Acirc;&agrave;&oslash;&aring;&eacute; &ocirc;&icirc;&eth;&igrave;&oacute;&euml;&aring; &iuml;&agrave;&igrave;&yuml;&ograve;&egrave; &auml;&icirc;&euml;&aelig;&iacute;&icirc; &eth;&agrave;&ntilde;&otilde;&icirc;&auml;&icirc;&acirc;&agrave;&ograve;&uuml;&ntilde;&yuml; &ccedil;&iacute;&agrave;&divide;&egrave;&ograve;&aring;&euml;&uuml;&iacute;&icirc; &igrave;&aring;&iacute;&uuml;&oslash;&aring;. &Egrave;&euml;&egrave; &ecirc;&agrave;&aelig;&auml;&ucirc;&eacute; &iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&ograve;&aring;&euml;&uuml; &Iuml;&Agrave;&ETH;&Oacute;&Ntilde; &egrave;&auml;&cedil;&ograve; &ccedil;&agrave; &auml;&acirc;&icirc;&egrave;&otilde;? &Acirc;&icirc;&ograve; &iacute;&aring;&iuml;&icirc;&iacute;&yuml;&ograve;&iacute;&icirc;.
&Iuml;&icirc; &ocirc;&icirc;&eth;&igrave;&oacute;&euml;&aring;:

Код:

shared_pool_size + db_block_buffer*db_block_size + ((sort_area_size+sort_area_size * 2+2) * êîë-âî ñåññèé )+log_buffers+java_pool_size

384+256+(10+20+2)*(40 &iuml;&icirc;&euml;&uuml;&ccedil;&icirc;&acirc;&agrave;&ograve;&aring;&euml;&aring;&eacute+64+64 = 2048 &egrave;&euml;&egrave; 2&Atilde;&egrave;&atilde;&agrave; &Iacute;&agrave; &auml;&aring;&euml;&aring; &icirc;&ograve;&uacute;&aring;&euml;&icirc; &acirc;&ntilde;&aring; 3&Atilde;&egrave;&atilde;&agrave;. &Icirc;&iuml;&aring;&eth;&agrave;&ouml;&egrave;&icirc;&iacute;&ecirc;&agrave; &iuml;&eth;&egrave; &acirc;&ucirc;&ecirc;&euml;&thorn;&divide;&aring;&iacute;&iacute;&icirc;&igrave; &icirc;&eth;&agrave;&ecirc;&euml; &ccedil;&agrave;&iacute;&egrave;&igrave;&agrave;&aring;&ograve; &iacute;&aring; &aacute;&icirc;&euml;&aring;&aring; 100&Igrave;.<br><br>Сообщение отредактировано: Alexander, в: 2004/12/22 13:42