Show TOC

Procedure documentationDatabase Console Locate this document in the navigation structure

 

The Diagnosis user menu of the DBA Cockpit contains a display of the information for runtime analysis of database system bottlenecks detected using the XCONS database tool (database console).

Procedure

  1. Open the DBA Cockpit (transaction DBACOCKPIT) and choose   Diagnosis   Database Console  .

  2. Select the required command. There are commands available for obtaining information from a wide range of different areas, for example, disk accesses, process analysis or memory management.

  3. Choose   Database Console   Execute Command  .

Caution Caution

For SAP NetWeaver 7.1, you can access the database console through the Database Console user menu.

End of the caution.

Result

The required information is retrieved from the database console and immediately displayed on the screen. You can save the results as a local file.

SYSMON Tables

If the database is in the ONLINE operational state, you can display the SYSMON tables. To do so, choose   Goto   SYSMON Table Display  .

Example Example

Displaying information about critical sections:

To do this, choose   Goto   SYSMON Table Display  . Enter table name SYSMON_REGION.

End of the example.

More Information

XCONS documentation

Utilities, XCONS Options for Displaying Information about the Database