Box 1 : ( NT, 2 cpu, 1.5 G Ram )

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 35 0.01 0.01 0 0 0 0
Execute 5246 0.47 0.51 0 0 0 0
Fetch 9947 1628.06 1635.03 892 162709051 0 4701
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 15228 1628.54 1635.55 892 162709051 0 4701

Box 2: ( NT, 2 cpu , 1 G Ram)

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 40 0.03 0.02 0 0 0 0
Execute 2908 0.32 0.40 0 0 0 0
Fetch 5641 3502.22 4858.18 1316417 164089855 0 2733
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 8589 3502.57 4858.60 1316417 164089855 0 2733


Box 1 is an export & import of data from box 2. The above is a TKPROF output from both boxes for similar operations.

Explain plan looks the same on both boxes and is running in a rule based environment

Version : Oracle 8.0.5.1.1
OS : NT / SP 6 ( Box 1 ) , NT / SP 5 (box 2)
Disk : simple disk layout

Any ideas.