From DB Optimizer
Jump to: navigation, search

Oracle: administrative waits

Administrative waits should be rare and only caused by actions taken by the DBA such as rebuilding indexes, switching log files or changing the size or the buffer cache.

alter rbs offline

buffer pool resize

index (re)build online cleanup

index (re)build online merge

index (re)build online start

switch logfile command

switch undo - offline

wait for possible quiesce finish