Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

8
  • So this is one big query alone that is running? Not some pl/sql code with loops and stuff? Commented Sep 1, 2019 at 23:18
  • Thanks game wu. Is this a query (read-only), or is this doing DML -- an update? Can you also tell me -- is this stable/reliable in its cost and performance, or do different parameters (dramatically) change the execution plan? Thanks Commented Sep 2, 2019 at 3:46
  • 1
    if DML then progress is displayed in the transaction table v$transaction. stackoverflow.com/questions/54215043/… Commented Sep 2, 2019 at 10:20
  • Is this only for one specific SQL, or for any kind of SQL statement? If this is only for one statement, you can create some estimates based on what you know about the query. But if you're looking for a generic program to estimate the completion of any query, that task is theoretically impossible. Commented Sep 2, 2019 at 19:01
  • 1
    Thanks game wu. Since this is a select, I would hope that materialization/caching could be considered as a potential alternative to a lengthy ad-hoc query, but presuming that isn't viable, I'd think similarly to @JonHeller -- since this is a single statement, you should be able to profile it over its range of parameters (dynamic sampling, etc.). Armed with that profile, you could hit V$_SQL_MONITOR (or V$_SQL_PLAN_MONITOR ) to measure % progress. Or if it is very stable, you could just estimate. Commented Sep 2, 2019 at 20:57