Oracle SQL Monitor Report

Use the below query to get SQL Monitor Report :- 

1. get SQL id for your query :-

select * from gv$sql

2. Monitor report :-

SELECT DBMS_SQLTUNE.report_sql_monitor (sql_id         => 'dsf4z2dc63cfp',
                                        TYPE           => 'TEXT',
                                        report_level   => 'ALL')
          "SQL Monitor Report - Text"
  FROM DUAL;

It will give you below details.

SQL Monitoring Report
SQL Text
Global Information
Binds
Global Stats
SQL Plan Monitoring Details