Tutorial Flow:




Determining the problem category


As part of the initial diagnosis, the database administrator looks for familiar patterns of symptoms to categorize the problem at a high level. This example uses the MON_GET_SERVICE_SUBCLASS table function.


Note: Set the refresh interval on the top right pane to 5 seconds.

Some metrics that indicate some general problem categories



From this evidence, the database administrator is able to rule out some common explanations for performance problems. The data server is expending more resource to process requests and statement execution processing is not slowed down. The slowdown is occurring either before or after statement execution.