Sunday, May 20, 2012

Find the status of current query on Oracle

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.

No comments:

Post a Comment