Oracle Database Discussions

Hello,

I have pl/sql procedure running from yesterday and it seems to be hung now. I know the procedure commits only at the end because if it fails then we dont want to preserve any changes made by it and it's change alot of data. So now the status of the session is still active but its not doing anything. Now can anyone tell me where to start looking into like where its stuck and for what reason. I checked the alert log there is no weird errors there and here are come information about the session:

SQL> select sid,event,wait_class from v$session_wait where wait_class <> 'Idle';

SID EVENT
---------- ----------------------------------------------------------------
WAIT_CLASS
----------------------------------------------------------------
1060 db file sequential read
User I/O

SQL> select * from dba_blockers;

no rows selected

SQL> select sid, wait_class, total_waits, time_waited from v$session_wait_class where sid = 1060;

SID WAIT_CLASS TOTAL_WAITS TIME_WAITED
---------- ---------- ----------- -----------
1060 Other 202 709
1060 Applicatio 1 0
1060 Configurat 290 6429
1060 Concurrenc 3221 27
1060 Commit 1 2
1060 Idle 747 7142
1060 Network 19 0
1060 User I/O 7309851 1826269
1060 System I/O 1976 2131

9 rows selected.

SQL> select wait_class, event, state, wait_time, seconds_in_wait
from v$session_wait
2 where wait_class <> 'Idle' 3
and sid=1060 4
5 order by wait_class, event, sid;

WAIT_CLASS EVENT
---------- ----------------------------------------------------------------
STATE WAIT_TIME SECONDS_IN_WAIT
------------------- ---------- ---------------
User I/O db file sequential read
WAITED SHORT TIME -1 0


SQL> select status, used_ublk, used_urec, log_io, phy_io from v$transaction;

STATUS USED_UBLK USED_UREC LOG_IO PHY_IO
---------------- ---------- ---------- ---------- ----------
ACTIVE 215976 12397869 109379220 10814750


I know its highly I/O bound but its stuck on the same statement from yesterday itself and not moving forward plus its not giving any errors too so dont know what it is waiting for. There are no locks or blocking session either. I know not committing is playing a role here but if the session is out of resources (amount of undo, open file handles etc) then should it be stuck like this or throw some errors?

OS: AIX 5L
Database: 10g R2

I would appreciate for any help.

Thanks
Daljit Singh