RE: Lots and lots of redo logs

>
> BTW - this is not a fair test of normal OLTP activity -
> some experiments I've been doing recently suggest
> that inside a PL/SQL loop the COMMIT does not
> cause a log file sync - if you check your
> redo synch writes
> and
> redo writes
> statistics, you may find that redo synch writes is
> extremely small (possibly 1, possibly 1 per log file)
> and you redo writes will almost certainly be less
> than the 15,000,000 commits you issued.
>
> I'm still working on the 'commit is not a sync'
> thing, but it really does seem that in pl/sql
> a 'commit is complete' BEFORE lgwr has written
> to disc.
>

Jonathan,

please, keep us in touch with the results (if any)

Regards,
Ed

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: EShevtsov_at_flagship.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).