Performance Tuning with SQLDeveloper
"This presentation is mostly a demo of Oracle's SQLDeveloper monitoring/tuning capabilities. For those who do not yet use that product, it will give an overview of those capabilities and, in all likelihood, make their mouth water. For those who know it already, it will open their eyes to some fantastic possibilities, right at their fingertips. The demonstration shows how to monitor a live performance problem, diagnose it in real-time, and fix it. In order to do that, we will have to - use Monitor Sessions and customise it - use the new DB Instance graphic monitoring console - optimise a statement, compare execution plans To accomplish those tasks, we will leverage SQLDeveloper's many user-friendly features, with tips and tricks galore along the way. We will also cover formatting code, AWR/ASH reports, command history, monitoring, the SQL Tuning Advisor, and how to learn more about the Oracle database thanks to SQLDeveloper! Attendees will leave with - tips to do their daily tasks faster - ideas to work smarter - the knowledge that SQLDeveloper can accomplish much more than meets the eye"