Load Profile

• Gives a high-level view of system intensity.
• Important metrics:
• DB Time(s) – Total time spent on queries and waits
• DB CPU(s) – Portion of DB time spent on CPU
• Executes (SQL) – Query activity volume
• Redo size (bytes) – Change rate and workload size

If DB Time is much higher than CPU, most time was spent waiting, not computing.