Our application/database is running very slow, nothing seems to be wrong with the instance everything seems fine except for slog redo log writes. I see a lot of the following waits in
v$session_wait.
Event Wait_time State
pmon timer 0 waiting
rdbms ipc message 0 waiting
rdbms ipc message 0 waiting
SQL*Net message from client 0 waiting
SQL*Net message from client 0 waiting
SQL*Net message from client 0 waiting
SQL*Net message from client 0 waiting
pipe get 0 waiting
pipe get 0 waiting
What do these indicate? I read somewhere that the wait_time 0 indicate there is problem in the network? How do I find out and tune this?
Thanks in advance.