Automatic Workload Repository
Oracle Automatic Workload Repository (AWR) is an Oracle feature that allows users to generate detailed database performance reports. It requires a Diagnostics Pack license. An alternative is Statspack - which doesn't require a license and requires a DBA to set it up properly - and it produces less detailed, but still useful, text reports.
See Oracle Base - AWR for more details on how to use it.