Re: too many logswitch ?

I would have expected 1,500 to 2,000 bytes per row of redo if you have been committing once every row, so you figure seems to be about 5 times too much.

Are you sure nothing else was going on, and that there were no indexes on the table ?

Are you sure that the redo block size is only 512 bytes on your platform ?

What do the 'redo size' and 'redo wastage' figures look like ? And how many redo blocks were written ? (see v$sysstat)

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

tedchyn_at_yahoo.com wrote in message <80hoct$574$1_at_nnrp1.deja.com>...
>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 ?
>
Received on Fri Nov 12 1999 - 15:05:30 CST