Hi,
I'm testing how fast informatica can take data from our 10.2.0.3 and using large (140GB 1 200 000 000 rows) table as source and doing simple
select * from large_table .
Here goes quite interesting wait time analyze :) .
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 186994 131.84 198.25 127545 314167 0 25431184
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 186994 131.84 198.25 127545 314167 0 25431184
Misses in library cache during parse: 0
Parsing user id: 400
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file scattered read 9122 0.33 64.71
SQL*Net more data to client 529327 0.00 8.34
SQL*Net message from client 186994 0.21 478.74
SQL*Net message to client 186994 0.00 0.30
db file sequential read 145 0.01 0.49
gc cr multi block request 6998 0.01 6.30
gc current grant 2-way 9 0.00 0.00
gc cr grant 2-way 67 0.00 0.03
The interesting part is ' SQL*Net message from client 186994 0.21 478.74'
so looks like from Informaticka point of view (client side) is lagging 478 sec , so its lagging .
Doing some math 25431184/186994 = 136 .
Could You share with me Your experience in that matter ?
Looks like to speed up I need to :
1. increase fetch size (not sure how to do that).
2. increase SDU client and probably server side .
Network is 100Mbit ethernet so about 10MBytes per second .
Regards
GregG