>
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).