Oracle Error ORA 03123 (operation would block)
956219Aug 16 2012 — edited Aug 16 2012I get this error when I try to access data from a oracle sql clientt software tools sqldeveloper and TOAD
The strange thing is if I use Oracle SQL*plus, it works fine. This problem will be occuring only in VIS Oracle EBS R12.1 database 11.1.0.7.
In the database side i checked the locks and ran the gather schema stats didn't help.
In the client side.. I reinstalled the Oracle client 11g and sqldevelper 3.1 on Windows XP service pack 3. didn't help
The strange thing is from the sql develope when i ran
select * from fnd_user --- it runs forever and get erro ORA-3123 and freezes.
select USER_ID,USER_NAME from fnd_user - Works fine.
Please help on this.