Time Statistics (Oracle)

An Oracle shadow process either runs actively on the PC (it uses CPU time) or else it waits. Wait situations can be divided into cases where the Oracle process is waiting because there is currently nothing for it to do ('idle waits') or where the Oracle process wants to run but first has to wait for a resource that is not yet available ('busy waits'). 'Total waits time' describes the sum of 'idle wait time' and 'busy waits time'.

Sessions busy is defined as (CPU time + busy wait time) / (CPU time + total wait time). CPU usage is defined as CPU time / Elapsed time. Time/ User call is defined as (CPU time + busy wait time) / User calls.

Note that the three ratios show mean values since database startup. If you want to determine the actual load at its peak, you should use the monitor's Reset -function.