This content has been marked as final. Show 6 replies
First of all: this is an international forum. You should use international (English) measurement units.
Secondly: You should answer the main question which is 'What it is waiting for'.
This means you need to find what INSERT statements are waiting for.
So, v$session_events, v$session_waits, etc.
You can just find some indication by tracing your own session, performing an INSERT, and consulting your trace file.
Senior Oracle DBA
Did you collect the system statistics?
Have a check on wait event for that session from v$session_wait
Check for dependent constraint & triggers on subjected table .
If wait event found to be "enq: TX - row lock contention” check for Foreign key & have indexing done on refereed columns
check for Foreign key & have indexing done on refereed columns........you meant "enq: TM - Index contention" right
If the storage didn't change, I don't think that shifting from Windows to Linux has anything to do with the extra time taken for insert. As mentioned by Sybrand already, what did you see for the session doing the insert as a reason for the wait? If you are licensed for it, ASH can also help.
By performing the export and import, you essentially upgraded your database. Were all of the mandatory post-upgrade steps completed ?
You should not use ANALYZE command - use DBMS_STATS