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
Index Usage – 1
-
In 12.2 Oracle introduced Index Usage Tracking to replace the previous
option for “alter index xxx monitoring usage”. A recent post on the Oracle
database ...
Acum 3 zile