Re: Autocommit in SQL+

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 26 Dec 2002 13:02:59 +0100
Message-ID: <2prl0v4bj9v2c8kmmpgghfa002j6a9amop@4ax.com>

On 26 Dec 2002 02:31:22 -0800, hansdegit_at_hotmail.com (Hans de Git) wrote:

>Hi,
>
>Has anyone ever tried to the autocommit setting in SQL+? Is it
>possible to see the commit statements in v$sqlarea? I not, in what way
>does Oracle commit the statements issued in the sql+ session?
>
>Granted, autocommit really sucks. However, we use a third party
>product that connects to our database using the autocommit setting. On
>an busy day (with only 60 sessions), the 'log file sync' wait event
>grow to unacceptable proportions. So I would somehow like to trace
>what is going on.
>
>Thanks in advance.
>
>Hans de Git

I would suggest that convincing the vendor their product sucks is a better option. A yet better option is to sue them, as you are going to pay $$ for extra and faster hardware to circumvent the issue. Basically you also seem to have a non-scalable application now. It also looks like *almost every* vendor transferring their sql-server junk to Oracle by means of *porting* is using autocommit. One way or another, those morons will only learn when they are being damaged as a result of this policy.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Dec 26 2002 - 06:02:59 CST