Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fusion Analytics Autonomous database Series:Exploring ADW Performance Telemetry

41
Views
0
Comments

Database statistics provide information about the type of database load and the resources being used by the database. To effectively measure database performance, statistics must be available. Oracle Database generates many types of cumulative statistics for the system, sessions, segments, services, and individual SQL statements. Cumulative values for statistics are generally accessible using dynamic performance views, or V$ views. When analyzing database performance in any of these scopes, look at the change in statistics (delta value) over the period you are interested in. Specifically, focus on the difference between the cumulative values of a statistic at the start and the end of the period. 

This video is a part of six-part series

1- Autonomous Datawarehouse- Connecting via SQL developer

2- Autonomous Datawarehouse- Schema Exploration

3- Autonomous Datawarehouse -Using Custom Schema

4- Exploring Autonomous Data Warehouse (ADW)

5- Exploring Autonomous Data Warehouse- Performance Telemetry

6- Exploring Data loads with Autonomous Data Warehouse