Thanks Vijay.

So initally I had only one thread of P001

p001 (Slave) 1 1 Rowid Range Scan GENEVA_ADMIN.OLD_ACCOUNT 41825 41825 Blocks 21-DEC-10 1058 1

where the totaltime = sofar. What I understood is that parallel session is completed. right?

but later I saw another session popped up

- p001 (Slave) 1 1 Rowid Range Scan GENEVA_ADMIN.OLD_ACCOUNT 7 28932 Blocks 22-DEC-10 1058 1 - p001 (Slave) 1 1 Rowid Range Scan GENEVA_ADMIN.OLD_ACCOUNT

I was thinking # of parallel session is static in this view. If P001 session is completed already, I was not expecting another session of P001. Otherwise how could someone estimate the remaining time of processes?

regards
Sumit