Re: catupgrd run time, 11gr2

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 26 Apr 2011 12:04:03 -0500
Message-ID: <BANLkTi=kXcymcqK-3e3L-h49-6xperNAtQ_at_mail.gmail.com>

I think everybody knows its not the size of the database. However, in at least 11gr2, it is a good idea to truncate the fga_log$ table and sys.aud$ table if you have a significant number of rows. On the first run through it took a long time while it was making row by row changes to those tables.

On Tue, Apr 26, 2011 at 11:41 AM, Michael Dinh <mdinh_at_xifin.com> wrote:

> It's not the size of the database, but the number of dependencies, e.g.
> synonyms.
>
>
>
> Great info here:
>
>
>
> http://blogs.oracle.com/UPGRADE/
>
>
>
> Michael Dinh
>
>
>
> NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential and exempt from disclosure under applicable
> laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH
> INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING,
> AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI
> CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT
> NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS
> MESSAGE. If the reader of this email (and attachments) is not the intended
> recipient, you are hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited. Please notify the
> sender of the error and delete the e-mail you received. Thank you.
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Andrew Kerber
> *Sent:* Tuesday, April 26, 2011 7:37 AM
>
> *To:* ORACLE-L
> *Subject:* catupgrd run time, 11gr2
>
>
>
> I am preparing for our upgrade from 10.2.0.4 to 11.2.0.2. However, the
> catupgrd is running ~ 3.5 hours. It doesnt appear to stop on anything in
> particular, so I am dubious about getting it to go faster. However, I
> thought I would ask, does 3.5 hours seem like a reasonable run time? Its a
> sun sparc system, 64 bit with 32 cpus and 128G RAM. Does anyone have any
> good methods for tuning the process?
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 26 2011 - 12:04:03 CDT