| 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: 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_at_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_at_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_at_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_at_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). Received on Wed Oct 25 2000 - 13:09:44 CDT
 |
 |