Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: why so many log switches?
I have 5 indexes on that table, 3 of them are concatenated indexes.
-----Original Message-----
Sent: Thursday, January 30, 2003 3:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: why so many log switches?
Those redo could be because of indexes? How many indexes do you have on your 40 million row table?
-----Original Message-----
Sent: Thursday, January 30, 2003 2: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).
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:55:43 CST
![]() |
![]() |