| 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?
So each insert generates redo on each of six segments plus redo for the
undo generated for each of the six segments.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London
-----Original Message-----
Randy
Sent: Thursday, January 30, 2003 2:56 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Cary Millsap
INET: cary.millsap_at_hotsos.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). Received on Thu Jan 30 2003 - 15:54:15 CST
 |
 |