Loading the Oracle Dev Gym leaderboards was taking a looooooong time.
The culprit?
Slow SQL statements.
To make the leaderboards load fast we needed to tune them. But first we needed to identify what was slow.
Watch this session to see how we used Oracle APEX debugging tools to profile the pages. Then reviewed the execution plans to figure out how to make the slow queries fast.
To learn more about Oracle SQL tuning, join the free class Databases for Developers: Performance
Share a link to this workshop via:
The QR code below is the URL for this workshop. Right-click to save the image to share with others.