Re: Applying Archive Logs for STANDBY Database
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: bnsarma@xxxxxxxxx
- Date: Fri, 28 Apr 2006 22:14:03 +0200
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@xxxxxxxxx>:
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
- References:
Other related posts:
- » Applying Archive Logs for STANDBY Database
- » Re: Applying Archive Logs for STANDBY Database
- » RE: Applying Archive Logs for STANDBY Database
- » Re: Applying Archive Logs for STANDBY Database
- » Re: Applying Archive Logs for STANDBY Database
- » Re: Applying Archive Logs for STANDBY Database
- » Re: Applying Archive Logs for STANDBY Database
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