Forum Stats

  • 3,770,401 Users
  • 2,253,103 Discussions
  • 7,875,442 Comments

Discussions

Real time sql monitoring interpretation.

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

  1. what does arrow mark means in the id column? does it indicate the operation is in progress?
  2. 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?
Tagged:

Answers