Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Time to run Catproc.sql

Re: Time to run Catproc.sql

From: Matt <mccmx_at_hotmail.com>
Date: 9 Sep 2004 00:25:54 -0700
Message-ID: <cfee5bcf.0409082325.4f7ca516@posting.google.com>


Is this normal?? Any suggestions as to why
> it could be taking so long would be much appreciated

I would recommend increasing the size of your redo log files... if they are very small (i.e. default), catproc.sql can take ages to run.

Try setting them to between 10 and 30 Mb.

Matt Received on Thu Sep 09 2004 - 02:25:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US