A customer from the US did contact me past week via LinkedIn and raised a question:
“Is it expected that my patch set upgrade from Oracle 220.127.116.11 to Oracle 18.104.22.168 takes over 3 hours?”
Of course, no – this is not expected.
This is the upgrade stats gathered post upgrade with utlu112s.sql:
SQL> @?/rdbms/admin/utlu112s.sql ; .
Oracle Database 11.2 Post-Upgrade Status Tool
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
. VALID 22.214.171.124.0 02:46:19
JServer JAVA Virtual Machine
. VALID 126.96.36.199.0 00:08:34
Total Upgrade Time: 03:06:47
No, this …Continue reading...