Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Real time sql monitoring interpretation.

Kramer1862May 20 2021

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?

Comments

Post Details

Added on May 20 2021
4 comments
75 views