AWR Reports

Checking the AWR reports regularly is a plus for administering AR System environments. If your business processes or workflows are complex, then you can get an AWR report from database system and identify the inefficient queries and bottlenecks of AR System. Important part of the AWR report for me is:
1) Query by Elapsed Time
2) Query by CPU Time
In the report, you can see how much DB query time a query takes and you can start to fix the query which takes the most. In Oracle databases, there is the Snapshot concept. Oracle regularly takes a snapshot of the database instance and stores it. You can generate an AWR report by giving two snapshot IDs, start and end. Probable statement for getting the AWR report would be:
SELECT output FROM TABLE (dbms_workload_repository.awr_report_text (<DB ID>, <InstanceID>, <BeginSnapID>, <EndSnapID>));