Message-Id: <10660.120193@fatcity.com> From: "Holman, Rodney" Date: Wed, 25 Oct 2000 13:09:44 -0500 Subject: RE: Waits on archiving If you are waiting on ARCH to write the logs performance will be nonexistant. If you ARCH has not completed its writing and you need the log, processing on the DB will STOP until it is completed. Solution: add more log groups or alter the size of your logs to be able to be written out in the necessary time frame. Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation rodney.holman@lodgenet.com Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -----Original Message----- From: David Turner [mailto:turner@tellme.com] Sent: Wednesday, October 25, 2000 1:56 PM To: Multiple recipients of list ORACLE-L Subject: Waits on archiving What is the best method to tell if performance is degrading because of waiting on the archiver to write logs? I'm running 8.1.6 for Solaris. Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: turner@tellme.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).