Hi All,
there is a table contains 79 columns (with one CLOB cloumn) with approximately 100 000 record, sometimes a problem occurs only with this table (only these previous days) when trying to insert, update, delete from this table the commit process hanged!! Why? and How to solve? I can't specify why this problem occurs!!!
We renamed the table and recreate it using EXPDP IMPDP commands, recreate triggers on it and repeat grants on it to the roles as the previous one, This steps solved the problem for one day maybe only but the problem returns!
Notes:
This table is on a table space otherwise users, I'm using Oracle DB 11g R2