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
Char problems - The semantics of comparing character columns of different types can lead to some confusion, so before I get into the main body of this note here’s a little...
Acum 2 zile