есть тормозной процесс, на первое место в трэйсе вылезло вот это
INSERT INTO T1
VALUES
(:B1 ,:B2 ,:B3 ,:B4 ,:B5 ,:B6 ,:B7 ,:B8 ,:B9 ,:B10 ,:B11 )
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 289 0.01 0.01 0 0 0 0
Execute 202739 77.38 698.04 2808 214631 8687766 202739
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 203028 77.39 698.05 2808 214631 8687766 202739
Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: 67 (recursive depth: 1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
buffer busy waits 9532 0.82 78.23
db file sequential read 2805 1.02 317.58
enqueue 2916 2.93 188.48
latch free 352 0.03 3.55
buffer deadlock 303 0.09 1.07
log file sync 41 0.71 5.88
log buffer space 2 0.03 0.06
log file switch completion 21 0.59 4.59
control file sequential read 24 0.66 1.82
async disk IO 386 0.00 0.00
db file single write 2 0.00 0.01
control file parallel write 4 0.02 0.05
rdbms ipc reply 2 0.01 0.01
********************************************************************************
необходимо ускорить процесс в 5 раз. Какие будут рекомендации ?