Monitoring

The Monitoring tab offers a filter to view performance insights, OS metrics, DB metrics, or a combination of all. It also includes a search bar to locate specific monitoring metrics charts. You can manually refresh metrics using the refresh button on the right.

Select time intervals of 1h, 3h, 6h, 12h, or 24h to display the data for that duration on each graph. The default time interval is 1h. Graphs display the averaged values over the selected period.

For custom time duration:

1. Select the Custom option, choose your desired date and time, and click Apply.

The Service Availability graph displays database service uptime, with green indicating availability and gray representing unavailability. Data is updated every five minutes.

Note: This graph represents the availability of the current primary node. For HA services, users can choose the specific node for which they wish to view metrics.

Graphical Metrics

These graphs display the most recent metrics for your database services, logically grouped into OS Metrics, DB Metrics, and performance insights.. Each graph has the following capabilities:

• To view the entire graph in an expanded, full-screen mode, click the full-screen button located in the top right corner. A new window will appear, presenting the graph with metrics displayed at 5-minute intervals.

• To examine a specific section of the graph in detail, use the selection zoom button located in the top right corner and drag on an area in the graph. This feature expands the chosen area, providing a more detailed view of the metrics.

• To select and drag a specific section of the graph, use the cross-hair cursor.

• To download the graph in three different formats, use the top right corner menu button. It supports svg, png, and csv formats. The svg and png format captures the graph and saves as it is, while in the csv format it creates an excel file with the captured data values of the metrics in the fields.

OS Metrics

The OS Metrics offers the graphical representation of the most recent collected operating system metrics:

• CPU Usage - This graph displays CPU resource usage for the database service in percentages at 10-minute intervals by default. For a 5-minute interval view, zoom in using the full-screen button located at the top right corner. It also provides ‘Used (latest) N’ where N is the latest CPU percentage used in a numeric value at the top left-side of the graph.

• System load average - This graph displays the amount of system load average for the database service as a count in the interval of 10-minutes by default. Displays the system load average for every one minute, five minutes, and fifteen minutes using three different colors in the same graph. For a 5-minute interval view, zoom in using the full screen button located at the top right corner. It also provides ‘1 min (latest) N’, ‘5 min (latest) N1’, and ‘15 min (latest) N2’ where N, N1, and N2 are the system load average counts in numeric value for one minute, five minutes, and fifteen minutes at the top of the graph respectively.

• Memory Usage - This graph displays the details of used and available memory in GiB for your database service at a 10-minutes interval by default. Displays the used and available memory charts using two different colors in the same graph. For a 5-minute interval view, zoom in using the full-screen button located at the top right corner. It also provides ‘Used (latest) N’ and ‘Available (latest) N1’ where N and N1 are the amount of used and available memory in GiB at the top of the graph.

• Swap Usage - This graph displays the details of used and free swap area in GiB for your database service at 10-minutes interval by default. Displays the used and free swap area charts using two different colors in the same graph. For a 5-minute interval view, zoom in the graph using the full-screen button located at the top right corner. It also provides ‘Used (latest) N’ and ‘Free (latest) N1’ where N and N1 are the amount of swap area used and free available in GiB at the top of the graph.

• Network Usage - This graph displays the details of sent and received data across the network in MiB/s for your database service at a 10-minutes interval by default. Displays the sent and received data charts using two different colors in the same graph. For a 5-minute interval view, zoom in the graph using the full-screen button located at the top right corner. It also provides ‘Sent (latest) N’ and ‘Received (latest) N1’ where N and N1 are the amount of sent and received data in MiB/s at the top of the graph.

• Filesystem: Root - This graph displays the amount of used and free root filesystem in GiB for your database service at 10-minutes of interval by default. Displays used and free root filesystem space using two different colors on the same graph. It also provides the latest count of used and free root filesystem space in GiB at the top of the graph.

• Filesystem: Data - This graph displays the amount of used and free data filesystem in GiB for your database service at 10-minutes of interval by default. Displays used and free data filesystem space using two different colors on the same graph. It also provides the latest count of used and free data filesystems in GiB at the top of the graph.

• Filesystem: Archive - This graph displays the amount of used and free archive filesystem in GiB for your database service at 10-minutes of interval by default. Displays used and free archive filesystem space using two different colors on the same graph. It also provides the latest count of used and free archive filesystems in GiB at the top of the graph.

• Filesystem: DB Software - This graph displays the amount of used and free filesystem for the database software in GiB for your database service at 10-minutes of interval by default. Displays used and free filesystems for the database software space using two different colors on the same graph. It also provides the latest count of used and free filesystems for the database software in GiB at the top of the graph.

• Throughput: Archive disk - This graph displays the rate at which data is written to or read from the archive storage (disk) expressed in KiB at 10-minutes intervals by default. Displays the read and written data using two different colors on the same graph. It also provides the latest amount of data read or written in KiB at the top of the graph.

• IOPS: Archive disk - This graph displays the number of input/output operations per second (IOPS) occurring on the archive disk as a count at 10-minutes of interval by default. Displays the read and written IOPS data using two different colors on the same graph. It also provides the latest count of IOPS data read or written at the top of the graph.

• Top Processes by CPU - This table displays the processes that are using the most CPU time. Displays three columns, Process ID (PID), Processes, and the average value in percentage of the CPU used. These process details are independent of the time range. This graph displays only the current data and not the older data.

• Top Processes by Memory - This table displays the processes that are using the most amount of the memory. Displays three columns, Process ID (PID), Processes, and the average value in percentage of the memory used. These process details are independent of the time range. This graph displays only the current data and not the older data.

DB Metrics

The graphs under DB Metrics are:

• Session Stats - This graph displays the count of active users, inactive users, and active background processes for active sessions of your database service at 10-minutes of interval by default. Displays active users, inactive users, and active background processes in three different colors on the same graph. It also provides the latest count of active and inactive users, and count of active background processes at the top of the graph.

• Disk IO - This graph displays the amount of read operations and write operations per second for your database service at 10-minutes of interval by default. Displays the read and write operations per second using two different colors on the same graph. It also provides the latest count of read operations and write operations per second at the top of the graph.

• PGA Memory Stats - This graph displays the amount of allocated, freeable, maximum available, and used PGA memory in MiB for your database service at 10 minutes of interval by default. It also displays all these using four different colors on the same graph. It also provides the latest amount of allocated, freeable, maximum available, and used PGA memory in MiB at the top of the graph.

• SGA Stats - This graph displays the amount of used, free, and total available SGA memory in GiB for your database service at 10 minutes of interval by default. It displays these using three different colors on the same graph. It also provides the latest count of used, free, and total available SGA memory at the top of the graph.

• Blocking Sessions - This graph displays the number of blocking sessions in your database service at 10-minutes of interval by default. It also gives the latest count of blocking sessions at the top of the graph.

• Sessions Utilization - This graph displays count of maximum limit and utilization of sessions for your database service at 10-minutes of interval by default. It displays these using two different colors on the same graph. It also provides the latest count of maximum limit and utilization of sessions at the top of the graph.

• Process Utilization - This graph displays count of maximum limit and utilization of processes for your database service at 10-minutes of interval by default. It displays these using two different colors on the same graph. It also provides the latest count of maximum limit and utilization of processes at the top of the graph.

• Transactions Utilization - This graph displays count of maximum limit and utilization of transactions utilization for your database service at 10-minutes of interval by default. It displays these using two different colors on the same graph. It also provides the latest count of maximum limit and utilization of transactions at the top of the graph.

• Wait times - This graph displays the wait in seconds for administrative tasks, application tasks, for commits, concurrent requests, configuration tasks, network traffic, scheduler jobs, and system tasks for your database service at 10-minutes of interval by default. It represents all these using different colors in the same graph. It also provides the latest count for each category at the top of the graph.

• Activity - This graph displays the counts of query execution, query parsing, users commits, and users rollbacks for your database service at 10-minutes of interval by default. It represents all these using different colours on the same graph. It also provides the latest counts of query execution, query parsing, users commits, and users rollbacks at the top of the graph.

• FRA Utilization - This graph displays how much of the allocated fast recovery area is currently in use in percentage for your database service at 10-minutes of interval by default. It also provides the latest percentage of FRA utilization at the top of the graph.

Performance Insights

Tessell Performance Insights is a database performance monitoring tool that allows to assess and analyze the load on the database within a specified timeframe. This tool enables users to identify bottlenecks and pinpoint areas where performance improvements are needed.

To enable performance insights, ensure that you create a Monitoring Infra in the Monitoring Performance Insights Infrastructure application under the DB Services app family.

After the monitoring infrastructure is deployed, this feature can be enabled optionally on each database service either during provisioning or using settings tab post provisioning.

1. Select View Detailed Insights to view the graph in a 5-minute interval.

2. Select time intervals of 1h, 3h, 6h, 12h, or 24h to display the data for that duration on the graph. The default time interval is 1h.

3. For custom time duration, select the Custom option and then choose your desired date and time, and click Apply.

Features

Database Load: Database load measures the level of session activity in the database. The key metric in Performance Insights is DBLoad, which is collected every second. The unit for database load is the AAS (Average Active Sessions) which is the measure of the average active connections in a specific timeframe.

Active Sessions

• An active session is a connection that has submitted work to the DB engine and is waiting for a response.

• A session is active when it is either running on CPU or waiting for a resource to become available so that it can proceed. For example, an active session might wait for a page (or block) to be read into memory, and then consume CPU while it reads data from the page.

Average Active Sessions

• It measures how many sessions are concurrently active on the database on an average within a given timeframe.

• Every second, Performance Insights samples the number of sessions concurrently running a query. For each active session, Performance Insights collects the following data:

  • Wait - Session state (running on CPU or waiting)

  • SQL statement

  • Host

  • User running the SQL

  • Database on which the SQL is running

• Performance Insights calculates the AAS by dividing the total number of sessions by the number of samples for a specific time period.

Top Dimensions

Top dimensions are the dimensions of the data corresponding to the DB Load within a given timeframe. These include:

• Top Waits: These are the top waits by db load on which database was waiting in a given timeframe.

• Top SQLs: These are the top sql queries by db load running on the database in a given timeframe masked and grouped by their type.

• Top Hosts: These are the top hosts that were contributing to most of the db load on the database in a given timeframe.

• Top Users: These are the top users that were contributing to most of the db load on the database in a given timeframe.

• Top Databases: These are the top databases that were contributing to most of the db load on the multi-database service in a given timeframe.