Hello folks.
I am in Oracle Enterprise Manager Console.
In the <database_name>: Instance > Sessions > <target session>. I double-click the icon in the far left column and it pulls up the "Edit Session" screen.
I go to the "Long Operations" tab and watch the query I'm running. Currently, it says it's been running for 11 minutes. This is OK (not great, but OK because it's a big query on several large tables, etc.). The question I have is regarding the progress indicator. It has shown 99% complete for about 10 minutes. It says it has 0 seconds left to finish. I've been here before: eventually, it will finish. But why does it say it's 99% done after 2 minutes, when in reality it has 10 or 15 minutes left before it finishes? In the "Active Operations" panel, all it says is "SQL Execution".
When I go to the "SQL" tab, I can see the execution plan. Is there a way to tell which step it's hung up on, i.e. which step is currently executing?
There must be a better way to watch the progress of a query. Is there?
Thank you for your help.
-Mike
I am in Oracle Enterprise Manager Console.
In the <database_name>: Instance > Sessions > <target session>. I double-click the icon in the far left column and it pulls up the "Edit Session" screen.
I go to the "Long Operations" tab and watch the query I'm running. Currently, it says it's been running for 11 minutes. This is OK (not great, but OK because it's a big query on several large tables, etc.). The question I have is regarding the progress indicator. It has shown 99% complete for about 10 minutes. It says it has 0 seconds left to finish. I've been here before: eventually, it will finish. But why does it say it's 99% done after 2 minutes, when in reality it has 10 or 15 minutes left before it finishes? In the "Active Operations" panel, all it says is "SQL Execution".
When I go to the "SQL" tab, I can see the execution plan. Is there a way to tell which step it's hung up on, i.e. which step is currently executing?
There must be a better way to watch the progress of a query. Is there?
Thank you for your help.
-Mike
