Database Console 

In the Tools user menu, (OLTP/ liveCache) you can find, among other things, a display of the information for runtime analysis of database instance bottlenecks detected when using the database tool XCONS (database console).

Procedure

...

       1.      Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10).

       2.      Choose Tools → Database Console/Console.

       3.      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.

       4.      Choose Database Console → Execute Command.

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 instance is in the operational state ONLINE, you can display the SYSMON tables. To do so, choose Goto → SYSMON Table Display.

Shows information about the critical regions:

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

See also:

XCONS, Displaying Information on the Database Instance