Trying to MONITOR a select SQL in 12c but NOT able to get it in gv$sql_monitor
Hi,
I am trying to monitor a sql in 12c but NOT able to get the entry in gv$sql_monitor.
select inst_id,sql_id,child_number,sql_fulltext,plan_hash_value,round(buffer_gets/executions) BGPE,round(elapsed_time/1000000) ETPS from gv$sql where sql_id='bazkknun1nz07';
1 bazkknun1nz07 0 3193250106 53623446 1974
I used to give the /*+ MONITOR */ hint to the select sql and execute via sqlplus on a non-sys user , while the sql is still running i try to get the gv$sql_monitor output but there i am not able to get that.
below the format i am trying to monitor it