autocommit ON but no commits visible in v$sqlarea

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 - 05:16:37 CST