SQL Developer support several types of tuning activities. These are:
- Explain Plan/ Autotrace and Diff
- Monitoring SQL
- SQL Tuning Advisor
- PLSQL Hierarchical Profiler
For Refactoring, there are several options as well, and these grow with every release.
- Code Surrounding
- Procedure extraction
- Local variable renaming
Instrumentation is a way of finding out what an application is doing, who is using it, how its doing and and how long it has taken. In order to look at this from a database application point of view, we can break application instrumentation into a number of key areas.
- Runtime registration
- Metric Collection
Each of these key areas have specific tools and processes which should be implemented as part of your application development and we will get into those in the section on Instrumentation.