Re: PL SQL commit not really a commit (Was: benchmark to disprove myths)

Jaap W. van Dijk wrote:
>
> On Thu, 05 Dec 2002 20:54:00 +0000, Connor McDonald
> <connor_mcdonald_at_yahoo.com> wrote:
>
> >
> >plsql may not be a good one to use for the test because commit are not
> >really commits so you get an artificial redo rate.
> >
>
> Okay, let's sidestep here for a moment. Can you tell me what is the
> difference between a COMMIT executed in say SQLPlus and one executed
> in PLSQL and where that is documented?
>
> Jaap.

See Jonathan's post...he's the one that first made me aware of this capacity. Some more details at www.oracledba.co.uk, click Misc, then "LGWR dilemma"

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."