2011-06-10

ORA-3136 WARNING: inbound connection timed out

A possible cause may be SGA latch contention 
The theory is that while the shared_pool was being re-sized in the SGA, Oracle grabbed a latch. The memory resize operation took a while and while Oracle held that latch, nobody could login.

See the following link : http://marist89.blogspot.com/2009/08/sga-latch-contention.html 


Niciun comentariu:

Trimiteți un comentariu