You could see high such waits in your database if you are using automatic memory management of the SGA ( the new feature in Oracle 10G )
Solution : Set manually the memory components of the SGA's database .
see also http://www.nocoug.org/Journal/NoCOUG_Journal_201008.pdf
Join Factorization - This item is, by a roundabout route, a follow-up to yesterday’s note on a critical difference in cardinality estimates that appeared if you used the coales...
Acum 3 zile