| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Applying Archive Logs for STANDBY Database
('binary' encoding is not supported, stored as-is)
I have seen *some* improvement in using parallel clause. Sorry, I didn't
measure the performance improvement though.
alter database recover managed standby database parallel 16;
As I remember, one process reads the log file, but the application of those change vectors were performed by slaves.. Depending upon your bottleneck, this may or may not help you though.
BN wrote:
> Greetings
>
> 2 CPU HP-UX 11.11 Oracle 9.2.0.7 <http://9.2.0.7> STANDBY Database
>
> Applying 450 Archive Logs of 20 MB each took 2.30 hrs,
>
> Is there a way to tune this to cut this time?
>
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 27 2006 - 15:56:42 CDT
 |
 |