The Unit of Work tab on the Client Application Analysis drilldown provides details and statistics about the currently executing unit of work. When the execution time for an application’s current unit of work is high ( Curr Uow Sec column in the list grid), use this tab to investigate this unit of work.
Optionally from this tab, you can start a tuning session on the SQL statement you are investigating.
These details identify the selected application whose current unit of work you are investigating:
This area shows the SQL statement that is currently executing for the unit of work.
These details describe the SQL statement that is currently executing for the unit of work, provide a breakdown of the SQL statement’s execution time, and show the most recently completed unit of work for the application:
These statistics provide activity counts for the SQL statement that is currently executing for the unit of work and describe how the current unit of work is impacting database resources: