Настройка Axapta 3.0 (Array fetch ahead, Buffer size, событие ожидания в oracle 10G SQL*Net message to/from client ). Долго выполняются пакетные задания.

[NemoFF]

По поводу запросов. Очень смущает ситуация например с таким запросом.

Цитата:

SELECT /*+ INDEX(A I_507CALENDARDATEIDX) FIRST_ROWS(100) */A.CALENDARID,
A.NAME,A.WORKTIMECONTROL,A.TRANSDATE,A.WORKTIMECLOSEDTYPE_IBA,
A.BASICCALENDARID_IBA,A.RECVERSION,A.RECID
FROM
WORKCALENDARDATE A WHERE ((SUBSTR(NLS_LOWER(DATAAREAID),1,3)=NLS_LOWER(:in1))
AND ((SUBSTR(NLS_LOWER(CALENDARID),1,10)=NLS_LOWER(:in2)) AND (TRANSDATE=
:in3)))


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 36 0.00 0.00 0 0 0 0
Execute 258799 23.76 25.79 0 12 8 0
Fetch 258799 6.79 11.75 797 1035196 0 258799
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 517634 30.56 37.55 797 1035208 8 258799

Misses in library cache during parse: 1
Misses in library cache during execute: 6
Optimizer mode: FIRST_ROWS
Parsing user id: 55

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 258799 0.00 0.17
SQL*Net message from client 258799 0.02 123.01
db file sequential read 797 0.10 4.94
latch: shared pool 3 0.00 0.00
SGA: allocation forcing component growth 200 0.01 3.10
latch free 3 0.00 0.00
********************************************************************************

Сами запросы отрабатываются довольно быстро.