Platform:Linux 7.4
Oracle : 11.2.0.4
I have a table t1 with 10 million rows , trying to create a long running session by using "insert into t1 select * from t1". In parallel, generated SQL monitoring report from another session using DBMS_SQLTUNE.report_sql_monitor as below.
SPOOL report_sql_monitor.htm
SELECT DBMS_SQLTUNE.report_sql_monitor(
sql_id => 'amcsgadfafmjx',
type => 'HTML',
report_level => 'ALL') AS report
FROM dual;
SPOOL OFF
Attached report here.
Questions are
what does arrow mark means in the id column? does it indicate the operation is in progress?
Say if there are more than 10 steps in the report, how to find out which steps are completed and which one is currently progressing?