Re: Most frquently used SQL- Set transaction isolation level

On 5 Sep 2003 11:06:41 -0700, OakRogbak_erPine_at_yahoo.com (OakRogbak_erPine_at_yahoo.com Kill the 2 trees in email address to reply) wrote:

>I have been generating statspack reports lately on my database and
>reading everything I can find to make the most out interpreting the
>reports. One document from Metalink tells me to look at the section
>"SQL ordered by Executions" because a small performance increase on a
>frequently used query can provide greater gains than a moderate
>performance increase on an infrequently used query.
>
>In the Statspack reports that I have generated for this database, the
>most frequently executed SQL is 'Set transaction isolation level read
>committed"
>
>I have read about this and somewhat understand it, but I cannot figure
>out why it is executed so many times. We have Cold Fusion Server
>Applications that are talking to our Oracle 8i database on Windows
>2000, so I don't know if this is something that Cold Fusion is
>automatically doing.
>
>Any ideas appreciated.

It is definitely NOT done automatically by Oracle, so it must come from client sw

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Sep 05 2003 - 17:03:16 CDT