Hello Experts,
I would like to derive an implementation where I could show the Near Accurate Progress bar/ Progress indicator to display the Total v/s completed v/s running status of SQL process that is running in background in Oracle DB.
The challenge I see here for which I need expert suggestions on best fit solution:
- How to predict/derive the Total execution time of the running Process in runtime itself - immediately when the SQL process execution starts? - (This is needed to perform the below calculation)
Completed so far / Total Execution time * 100 ===> progress in percentage
- The SQL process scoped using Begin ...End and then Commit , so how to observe the "Completed process so far" during run time ?...as the initial status would be 0% and will turn up to 100% only after SQL process commits.
Do we have any sample APEX Application with progress bar that serves the requirement here.
please note we are using APEX 5.1 version and the SQL process for which we want to show the Progress of % completion generally takes 45 Mins to 1.5 hours depending on the Data and other Env factors.
Please advise on above queries to get this requirement fulfilled.