with the_sql_monitor as (
select a_great_way_to_see,
real_time_execution_plans
from your_painfully_slow_queries
where tuning_pack_license = 'Y'and the_boss = 'screaming for the result'
)
select *
from the_sql_monitor
where real_time_execution_plans =
'taking !$@# forever to run';
This really is an outstanding feature to help track the progress of that 4 hour SQL query,
showing which part of the execution plan is chewing up all the time so you know where to direct your tuning efforts