Originally posted by learning_bee
as I mentioned earlier, I am suspecting I/O and lock, but I am not sure how to point out it's lock contention.

Do you have any advises of how to go by???
The first step is to ensure that you completely understand the Oracle locking mechanisms -- see http:///tahiti.oracle.com for the Concepts Guide.