User session hung
The top command showed high usage of CPU. AWR report does show some I/O and row lock contention. But the lock contention is for another table which has nothing to do with the session that hangs. What would cause the unnecessary I/O bottleneck? Also, usually insert and updates would cause the db writer to be busy and generate logs, correct? At that time we had about 4 log switch in 30 minutes.