Home / Educational Content / Database & Technology / Insider’s Guide to Maximizing SQL Performance

Insider's Guide to Maximizing SQL Performance

Presented at INSYNC 21

Session ID: 101130

Automatic Workload Repository (AWR), Active Session History (ASH) and SQL monitoring hold a wealth of SQL performance data. OOCI Operations Insights SQL Warehouse leverages the rich SQL data in AWR, ASH, data using purpose-built machine learning to provide unique insights into SQL performance problems for your enterprise databases running on premise or on cloud. In this session learn to recognize patterns of SQL performance issues across all your Oracle Databases; perform a historical, comparative analysis to find any SQL bottlenecks or plan regression; and identify SQL performance anomalies.

Watch the full-length video

Premium Content: access is limited to Quest Corporate and Professional members.

Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.

Insider's Guide to Maximizing SQL Performance