Hi,
we are using MII 12.0.2 and Oracle 10g as database. Last week, we have moved some 3.2 million records from Table1 to Table2 and deleted those moved records from table1. Table1 is base table and we are inserting records to this table.
After this move and deletion operation, MII -> Oracle data insert is very slow. It is taking more than 40 to 50 sec to insert single record from MII applications to oracle (table1). And also it is taking more than 10 sec to execute simple select query from table1. Table1 has low records now (400000). But MII -> Oracle operations are very slow.
What causes the problem ? How to solve it?
Regards,
Senthil