![]() |
#3 |
Участник
|
По поводу запросов. Очень смущает ситуация например с таким запросом.
Цитата:
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 ******************************************************************************** |
|