From the course: Oracle HeatWave MySQL Foundations
Unlock this course with a free trial
Join today to access over 25,600 courses taught by industry experts.
Monitoring data loading
From the course: Oracle HeatWave MySQL Foundations
Monitoring data loading
(gentle music) - Welcome to this lesson on monitoring the data loading operation. It shows the commands to monitor the load progress, and table level load status, and change propagation status. You can monitor the following information about data loading. You can monitor the overall load progress of an ongoing data loading operation, and the load progress of individual tables. The progress is shown in percentage. You can check the load status of individual tables. The load status indicates the state of the data load in each table. You can also check whether the change propagation of individual tables is enabled or not. You can monitor the overall load progress at table level load progress. You can monitor the overall load progress and table level load progress. Run this query to view the global status variable named rapid load progress. It shows a percentage of the overall load progress of all tables that are being loaded. The value is 100 if all tables have been fully loaded. Run…
Contents
-
-
-
-
-
-
(Locked)
Loading data into a HeatWave cluster: Overview3m 16s
-
(Locked)
Loading data manually6m 3s
-
(Locked)
Loading data using Auto Parallel Load7m 30s
-
(Locked)
Monitoring data loading3m 4s
-
(Locked)
Unloading data4m 46s
-
(Locked)
Practice 2: Overview2m 32s
-
(Locked)
Practice 2-1: Loading data manually into a HeatWave cluster6m 24s
-
(Locked)
Practice 2-2: Loading data with Auto Parallel Load5m 9s
-
(Locked)
Practice 2-3: Monitoring data loading into a HeatWave cluster2m 58s
-
(Locked)
Practice 2-4: Unloading data from a HeatWave cluster5m 5s
-
(Locked)
Offloading queries to HeatWave4m 33s
-
(Locked)
Debugging queries3m 53s
-
(Locked)
Practice 3: Overview1m 12s
-
(Locked)
Practice 3-1: Offloading queries to HeatWave cluster5m 8s
-
(Locked)
Practice 3-2: Debugging queries that are not offloaded to HeatWave cluster5m 15s
-
(Locked)
-