Database is usually a shared environment but our tuning goal may focus on one application at a time.
ASH data contains a set of application-related variables for us
to identify different applications running against database. Those application-related variables include
user name, service name, module, action, program, machine(11g only), client ID.
This example describes a scenario of how to start troubleshooting SQL performance issue for a specific module.
We can apply this module-based SQL tuning strategy to other application-related variables such as user-based, or service-based, etc.
DBspeed offers you the option to select any application-related variables and their combinations using few clicks!