This content has been marked as final. Show 3 replies
Please see the following docs.
Patch is hanging for A Long Time all patch workers are in status Waiting [ID 1470763.1]
Srini Chavali wrote:Note: Keep in mind that the time that it takes on online index build to complete is proportional to the size of the table and the number of concurrently executing DML statements. Therefore, it is best to start online index builds when DML activity is low.
How many rows are in the table ? What is the database version ? One possible option is to create the index online, while the upgrade is running.