Oracle upgrade duration

[Former Member]

Hi All,

We completely understand that when we are upgrading oracle db we are just patching the binaries and not touching the data.But a db with higher size would definitely take longer time for the upgrade right.Thanks.

[stefan_koehler · Accepted solution]

Hello Ambarish,

if you upgrade your database you are also upgrading data and structures in SYS, SYSTEM and SYSAUX (or other oracle product schema owners).

The upgrade duration does not depend on your database size - it will depend on your hardware (mainly CPU) and on your installed database components (DBA_REGISTRY). All SAP Oracle databases have usually installed the same components - so it will take nearly round about 1.5 to 2 hours.

Regards

Stefan

[nirmal_konchada · Accepted solution]

Hi,

I too think that the DB size doesnt matter during upgrade but if you go through the upgrade guide for 11g it says that "the upgrade time may vary to some extent depending on the size of the DB and quality of hardware"

Regards,

Nirmal.K

[Former Member · Accepted solution]

Thanks Stefan as always.Thanks.

[former_member204746]

An Oracle upgrade wil ltouch objects from SYSTEM and SYSAUX tablespaces. the rest is mostly ignored.

so, an upgrade to a 100GB DB or 2TB DB is almost the same.

[Former Member]

Hi Ambarish,

Database size is independent from the db upgrade runtime. This is because, upgrade process does not touch the data itself.

Best regards,

Orkun Gedik

[Former Member]

Dont we have to recompile the stuff.Will it not take long time.Thanks.

Edited by: Ambarish annapureddy on Aug 18, 2011 12:06 PM

[Former Member]

Dont we have to recompile the stuff.Will it not take long time.Thanks.
> 
> Edited by: Ambarish annapureddy on Aug 18, 2011 12:06 PM

Hi Ambarish,

Of course, db objects will be recompiled during the upgrade. Upgrade runtime depends to your hardware. For example, my last upgrade process took approximately 2 hours, from 10g to 11g.

Best regards,

Orkun Gedik