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
Announcement: Oracle Indexing Internals Seminars Coming to New Zealand in March 2018 (Shipyards of New Zealand) - I’m very pleased to announce I’ve now finalised some dates in New Zealand for my popular and highly acclaimed “Oracle Indexing Internals and Best Practices...
Acum o zi