Zdravstvuite ,
Dage ne znaiu kuda pisat' ili na forum Java ili na Forum Oracle (piscu v dva Foruma).
U nas est' Batch napisannii na Java kotorii vizivaet Oracle . Problema v tom cto kogda mi ego trassiruem to v itoge polucaem cto-to v etom rode(vipiska iz trace_file obrabotannogo TKPROF):
SELECT *
FROM TBLEGAMI
WHERE CDCOMUNICAZIONE = :1 AND CDTPLEGAME = :2 AND CDTPENTITA = :3 AND CDLIV1 = :4
AND CDLIV2 = :5 AND CDPROP = :6 AND FLSTATO = :7
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 547 0.01 0.10 0 0 0 0
Execute 547 3.74 9.82 0 0 0 0
Fetch 466 0.15 0.74 0 985 0 466
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1560 3.90 10.68 0 985 0 466
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 5102 (User_id)
Rows Row Source Operation
------- ---------------------------------------------------
1 SEQUENCE (cr=2 pr=0 pw=0 time=16442 us)
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT MODE: ALL_ROWS
1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'TBLEGAMI'
(TABLE)
0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'XS4_TBLEGAMI' (INDEX)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
latch: shared pool 1364 0.04 8.39
SQL*Net message to client 1013 0.00 0.00
latch: library cache 18 0.01 0.08
********************************************************************************Skagite pogaluista - normal'no cto Parse = Execute i takoe bol'scoe cislo .
V etom batche krutitsia cto-to 11 takih query(korotkih). Etot batch dolgen sozdat' okolo 1200000 documentov . Tak vot degradazia batcha nacinaetsia posle pervih 150000 documentov - to est' proisvoditel'nost' padaet s 20 documento v sec. do 4 documento v sec. V odnoi is tablic est' kolonka s datatype CLOB - no v etu tablicu tol'ko zapicivautsia dannie - documenti. Na cto nugno obrascat' vniamnie v pervuiu ocered'.
Cto do menia - to v Java polnii profan.
Viskagite svoe mnenie.
bol'scoe spasibo vsem .
Ne rugaites' .