| 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,
This is a long shot... but..
do you run hot backup when the data gets loaded?
-----Original Message-----
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: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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 - 18:14:30 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |