Pando,

It's certainly hang b/c it not doing anything when it reach certain number, it just sit there.

Below is second select on V$session_wait.. this is the second one when I already got rid of the first one.

19 3218 direct path read file number 1001 000003E9 first dba 118095 0001CD4F block cnt 1 00000001 -2 68 WAITED UNKNOWN TIME


I have one session ran from last night till this morning and it's not going anywhere, The same procedure ran on 9i and it ran in less than a min.

Any thoughts???