-
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.
-
You generally do not need to worry about SQL Net messages if you are sure that your network is fine because what they mean is the server is waiting for the client to respond to something or pass on some input.
The problem lies elsewhere.
Nizar
-
Nabaig is right.
Have you tried any performance tuning scripts ?
buffer hit ratios
I/O stats
rollstat
sort stats
etc
have you tried tracing slow session and analyzing sql ?
this can result in major gains !
have you tried querying v$waitstat, v$sysstat etc ?
