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
opt_estimate 2 - This is a note that was supposed to be a follow-up to an initial example of using the opt_estimate() hint to manipulate the optimizer’s statistical underst...
Acum 9 ore