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
Show parameter - Just a quick little tip for Friday afternoon. If you use the “show parameter” or “show spparameter” commands from SQL*Plus you’ve probably noticed that the...
Acum 19 ore