Most frquently used SQL- Set transaction isolation level

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. Received on Fri Sep 05 2003 - 13:06:41 CDT