Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Most frquently used SQL- Set transaction isolation level
OakRogbak_erPine_at_yahoo.com (OakRogbak_erPine_at_yahoo.com Kill the 2 trees in email address to reply) wrote in message news:<13fdc9b4.0309051006.18ded648_at_posting.google.com>...
> 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.
This is most likely generated by your ODBC driver for every new connection
/Erik Received on Mon Sep 08 2003 - 08:42:07 CDT