From the course: Oracle HeatWave MySQL Foundations
Unlock this course with a free trial
Join today to access over 24,000 courses taught by industry experts.
Practice 4-1: Viewing query runtime with Query Insights
From the course: Oracle HeatWave MySQL Foundations
Practice 4-1: Viewing query runtime with Query Insights
(steady music) - [Hope] Welcome to "Practice 4-1: Viewing Query Runtime with Query Insights". We're going to assume that you have access to an Oracle Cloud Infrastructure account that's been configured for this course and that you're logged in. We'll also assume that you successfully completed all of module one, two, and three practices. To start in your OCI console, select Developer Tools and Cloud Shell. I'm going to maximize for easier viewing. Once your Cloud Shell is started, you'll need to change your network. Select Expand, and Ephemeral private network setup. Confirm that your compartments are correct. Your compartment numbers here should match the same numbers that are in your profile. Once you've confirmed that your VCN compartment and your subnet compartment is correct, set your VCN value to MDSVCN and set your subnet to MDSVCNPRVNET for your private subnet. Click Use as active network. While it's connecting, you'll see connecting in parentheses up here with the status bar…
Contents
-
-
-
-
-
-
-
(Locked)
Overview of advisors4m 2s
-
(Locked)
Auto Encoding Advisor5m
-
(Locked)
Auto Data Placement Advisor5m 42s
-
(Locked)
Query Insights4m 44s
-
(Locked)
Auto Unload Advisor4m 47s
-
(Locked)
Practice 4: Overview1m 48s
-
(Locked)
Practice 4-1: Viewing query runtime with Query Insights3m 30s
-
(Locked)
Practice 4-2: Identifying tables to unload with Auto Unload Advisor2m 59s
-
(Locked)
Practice 4-3: Optimizing string column encoding with Auto Encoding Advisor2m 46s
-
(Locked)
Practice 4-4: Optimizing partitioning columns with Auto Data Placement Advisor3m 17s
-
(Locked)