No, i was querying v$session_longops for the sessions running more than 5 seconds but it didn't show any thing.

The tables involved in the script are very small; not even 10k rows in each table but undo records used crossed more than 15M at one time. Now, i killed the session and recovery is going on. Once recovery is complete then I am planning to create new undo table space and switch.

Thanks,