To find the status of Create Table, or to find the status of rebuild Indexes or to find the status of update statement, use the below query:
SELECT sid,
sql_id,
status,
plan_line_id,
plan_operation || ' ' || plan_options operation,
output_rows
FROM gv$sql_plan_monitor
WHERE SID = 136 --sql_id = 'ca1ndmvmh7xqf'
AND status NOT LIKE '%DONE%';
you need to get the SID from the session browser for the current query and substitue in the above query.
SELECT sid,
sql_id,
status,
plan_line_id,
plan_operation || ' ' || plan_options operation,
output_rows
FROM gv$sql_plan_monitor
WHERE SID = 136 --sql_id = 'ca1ndmvmh7xqf'
AND status NOT LIKE '%DONE%';
you need to get the SID from the session browser for the current query and substitue in the above query.
No comments:
Post a Comment