ORCIDGitHubLinkedIn
RSS Curriculum Vitae TR

Automatic Workload Repository

Turkish equivalent: Otomatik İş Yükü DeposuDomain: Oracle

Oracle's built-in repository of periodic database performance snapshots used for workload, wait-event, SQL, and resource analysis.

Technical Context

AWR is most useful for comparing intervals and identifying where database time is spent. A report is evidence, not a diagnosis by itself: workload changes, DB time, wait classes, top SQL, I/O, CPU saturation, and plan changes must be interpreted together.

  • Oracle wait event
  • SQL tuning
  • DB time
  • execution plan

Updated:

Related concepts

Oracle