Hi all,
11.2.0.1
To end-up the delete issue once and for all, I ask the batch operator to run the delete script so I can check the blocking programs.
This delete program runs for 30 mins only deleting 1 million rows, and now again I hanged and is running more that 1 hour.
So I run the check-blocking-program script, and this is the result (while the delete program is hanging).
| BLOCKING_STATUS | PROGRAM | SQL_ID | SQL_TEXT |
ADMIN01@appsprod(INST=1 SID= 9)
is blocking ADMIN01@WORKGROUP\OPER-DEP-MIS (INST=1 SID=178) | Toad.exe | 39v74npm7s7sd | delete from EMP where emp_date='18-AUG-13' and dep_id=0 |
Why is that the blocker itself is the program being run? It is blocking itself?
If it is blocking some other programs, why is it hanging?
Please help....
I thank you all,
zxy