Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: autocommit ON but no commits visible in v$sqlarea
Try not using auto commit. The waits will probably go away if you do.
Autocommit is not a good idea.
Jim
"Hans de Git" <hansdegit_at_hotmail.com> wrote in message
news:72383d4a.0212250316.bdf8945_at_posting.google.com...
> Hi,
>
> We use an OCI application which connects to our database using the
> autocommit setting ON. When I emulate such a session using SQL+ (set
> autocommit on) I cannot see any COMMIT statements in v$sqlarea. How is
> that possible? I always believed that ALL changes to the database were
> visible in the v$ views....
>
> I would like to have some kind of control over those sessions, because
> we are experiencing a lot of waits on the 'log file sync' event, which
> pretty much prevents us from allowing more users to use this
> application concurrently (the wait would grow to unacceptable
> proportions).
>
> Any suggestions would me much appreciated.
>
> HTH,
>
> Hans de Git
Received on Wed Dec 25 2002 - 07:44:39 CST