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
Question Time - It’s that time of year again – the UKOUG Tech conference is approaching and I’ve organised a panel session on the Cost Based Optimizer. This year I’ve got ...
Acum 3 zile