| 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: why so many log switches?
Randy,
You may have 9meg of data, but that does not translate into 9meg of redo. In addition to the insert into the table, you also insert into indexes (if existing), generate undo for each operation (1 entry for table, 1 for each index), space management operations (extent allocation, index leaf splits). Granted inserts are the operations that consume the least amount of undo space (but not by very much), but they still consume space for which redo entries must be written.
Has it always been like this? Or has the amount of redo suddenly increased?
Dan Fink
-----Original Message-----
Sent: Thursday, January 30, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
I have a table with 40 million rows. Daily I load about 70,000 records into it. Each record is 128 characters wide. The flat file the data comes in is 9 megs. My redo logs are 20 megs each and I have 3 groups of them.
When I load the data, the alert log shows 29 log switches which generates a lot of archives logs. Why am I getting so many log switches? I would think that if the OS file is 9 megs and the redo logs are 20, I would at most get 1 log switch.
Thanks,
Randy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steiner, Randy
INET: RASTEIN_at_NYCT.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Thu Jan 30 2003 - 14:23:31 CST
 |
 |