MII - DB Performance is slow

[Former Member]

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

[Former Member]

Hi,

First try to insert data manually into Table1 from oracle 10g & find out how long will it takes.

If insertion is fine @ oracle end, then look for SAP MII (How you are inserting), else problem is with the table ( Take help of Oracle DBA to proceed further)

Thanks

Rajesh S

[Former Member]

Hi,

Restart both the servers and check the performance.

Use stored procedure for any insert/update operations to optimize the performance.

Best Regards,

Kedar

[agentry_src]

Take a look at your database transaction log file. It is probably huge from the record movement. Get a Oracle db to integrate the transactions into the database and also reindex the tables. You should see a big improvement in performance.

Regards,

Mike