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
Oracle 19c Automatic Indexing: Index Created But Not Actually Used (Because Your Young) - The following is an interesting example of how Oracle Automatic Indexing is currently implemented that can result in an Automatic Index being created b...
Acum 3 ore