You didn't mention is this a logical or physical standby. If physical
than tuning is the same as for database recovery - you can find plenty
in the net as well as some sugestions already given in this thread.
Loagical standby is a different beast.
Anyway, sampling v$session_wait can give you good information on where
your sessions (if parallel) are spending their time.
2006/4/27, BN <bnsarma_at_gmail.com>:
>
> Greetings
>
> 2 CPU HP-UX 11.11 Oracle 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?
>
> --
> Regards & Thanks
> BN
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 28 2006 - 15:14:03 CDT
