1738665 - ASH and AWR report creation in SQLPLUS and DBACOCKPIT

Symptom

This document shows and lists all steps to create ASH /AWR reports in an SAP environment for Oracle databases.

ATTENTION: A lot of crucial information for Oracle performance analysis is NOT collected by the reports below. Therefore, provide in any case the information described in note 3073074 - Oracle Performance Issue - Data Collection.

Environment

Oracle Database 10.2 and above
SAP Release independent
OS Release independent

Keywords

ASH,AWR,Report,11.2,10.2,12.1,Active Session History,Automatic Workload Repository,performance,DBACOCKPIT,monitor,lock,blocking,problem,ST04,analyze,report,html,bottleneck , KBA , BC-DB-ORA , Oracle , BC-CCM-MON-ORA , Database Monitors for Oracle , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.