Q: too many logswitch ?

Sir,

1. Inserting into a table(max rowlength 300 bytes,NO index) via odbc driver.
2. after insertion table size is 7m with 100,000 rows
3. logswitch 170 times redo log size 5m total logfile consumption 750m(170 x 5) log_checkpoint_timeout is set to 0 log_checkpoint_interval is set to 100,000 os block size(512bytes)
4. the ratio of redo cosumption to size of table is almost 100.

questions,
1. what control log switch ? if logswitch takes place when it is filling up then one would assume during switch redo is almost full? 2. why redo conumption is so high for the number bytes inserted into

   the table ?

Thanks in advance
ted Chyn

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 12 1999 - 13:05:05 CST