Oracle Database for SAP: Manageability

One of the many positive aspects of the Oracle Database for SAP is the area of manageability, diagnosability and supportability. Compared to any other database platform, Oracle Database offers the most sophisticated options for in depth analysis. The evaluation of the data provided by the Oracle Advanced Workload Repository (AWR) and the Advanced Session History (ASH) allows root cause analysis on every desired level. This is a huge benefit every time you run in a performance problem or any other error situation. The SAP and Oracle support lines can act very effectively based on those features. The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.

DBA Cockpit is a platform-independent tool that you can use to monitor and administer your Oracle database and Real Applications Clusters. It provides a graphical user interface (GUI) for all actions and covers all aspects of handling a database system landscape. It provides the relevant functionality from the old transaction codes ST04, DB02, DB13 (DBA Planning Calendar), DB12, DB14, and DB13C and also includes several monitors, particularly for Oracle 10g. DBA Cockpit includes the monitoring of Oracle RAC and remote Oracle databases, and even the monitoring of non-Oracle databases (both ABAP and non-ABAP systems) is possible with MultiConnect. DBA Cockpit uses the Oracle Diagnostic Package including Active Session History (ASH), Automatic Workload Repository (AWR), and Automatic Database Diagnostic Monitor (ADDM).

One of the essential elements of any SAP system landscape is the relational database system, which contains and administers all persistent data of the SAP system. Therefore SAP offers BR*Tools Studio, which is a powerful database administration (DBA) package for Oracle databases. BR*Tools Studio is a browser-based web application that lets you select the database tasks known from BR*Tools and then instructs BR*Tools to run the chosen task on the relevant database.