Welcome to Oracle University's Oracle Cloud Infrastructure Course on Monitoring Autonomous Database. My name is Kay Malcom. I am a Senior Director with a Database Product Management Team. The metrics resource page is presented on the details page of your autonomous database for ADB Instance. These metrics help identify the performance of the database. The page shows both current and historical information about the utilization of the service. I'm going to go through some of the areas. The storage shows the percentage of provision storage capacity that is currently in use. It represents the total allocated space for all of the table species. The CPU utilization is expressed as a percentage. It's aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs. The number of sessions in the database is displayed under sessions. Execute count shows the number of user and recursive calls that executed SQL statements have run during the selected interval. The number of running SQL statements aggregated across all consumer groups during the selected interval is displayed under running SQL statements. Queued statements shows the number of queued SQL statements aggregated across all consumer groups during the selected interval. The metrics data is graphed using the start and end times you select at the top of the charts. From the Cloud Console, you have additional information about the Instance that is running the database. On the same page, there is an activity button on the left. Click the button. The activity page has two main tabs, Monitor and Monitored SQL. The Monitor tab, which is also the landing tab for activity, shows the real-time and historical information about the utilization of the service. There are several components on this page. Let's go through them now. Database activity. This chart shows the average number of sessions in the database using CPU or waiting on a Wait Event. CPU utilization shows the CPU utilization of each consumer group. Running statements is the average number of running SQL statements in the consumer group. Queued statements, the average number of queued SQL statements in each consumer group. In the monitor screen, you can see real-time activity or historical time period activity. Select the type of monitoring you wish to do. Regardless of whether you are analyzing in real time or time period data, the type of information displayed in the graphics is the same. The first chart shows database Wait Events including application concurrency, CPU, schedule, user I/O, and other wait events. The second chart shows CPU utilization by the database defined service name. Now as a reminder, specific service names are predefined in autonomous database. In this case, high, medium, and low are the autonomous data warehouse service names for this example. The third and fourth charts display the number of running and queued SQL statements, also defined by service name. It shows a number of statements running per service. To analyze specific SQL statements, click the "Monitored SQL" tab. This tab displays the SQL completed or running in chronological order. Upon scrolling the table to the right, you can see the consumer group and the parallel degree that was used by the SQLs. Right-click any row and select show details for more details on any executed SQL. When you click "Monitored SQL", information on executing queued and completed SQL is displayed in chronological order. It shows the status, the SQL texts, duration, and other pertinent information. From this screen that you see, you have the ability to cancel any running SQL statement by selecting the statement and clicking Cancel Execution. That will stop the running SQL statement. For detailed offline analysis of the SQL statements that are running or that ran on your Instance download the report by clicking, you guessed it, Download Report. For a detailed explanation of any particular SQL statement, select that statement, and then select "Show details". Now this is going to show you some substantial details about the running transaction. You can view real-time and historical performance data from the Performance Hub. The Performance Hub page is displayed on your screen. This page has the following sections. The time selector, the reports drop-down list which contains the option to create and download an automatic workload repository report or AWR. The tabbed data area with the tabs, ASH analytics, SQL monitoring, ADDM, which is the automatic database diagnostics monitor, workload, and blocking Sessions. In this module, we talked about all of the different metrics available for you to monitor your autonomous database. Thanks for watching.
