Funny you should ask. I just (3:05pm to 3:30pm EST) ungraded a 10.2.0.4.3 database to 11.1.0.7.0 that was about 15GB. And, now i'm about to upgrade a 171GB database. I'll mail the list with the timing. I would guess that 10.1 to 10.2 would be even quicker then what i'm doing. Lyall -----Original Message----- From: Joel.Patterson@xxxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx Sent: Mon, Mar 15, 2010 3:42 pm Subject: Time to upgrade verses size of DB I didn’t want to open an SR just for this question. For downtime scheduling purposes -- Upgrading from Oracle 10.1.0.2, or 10.1.0.4 to 10.2.0.4 (on Solaris 5.10, (or any OS)): Does the time it takes to upgrade significantly change depending on the size of the database? e.g. Will a 200Gb database upgrade in essentially the same time window as a 20Gb database? Best Regards, Joel Patterson Database Administrator 904 727-2546