Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Most frquently used SQL- Set transaction isolation level

Re: Most frquently used SQL- Set transaction isolation level

From: OakRogbak_erPine_at_yahoo.com Kill the 2 trees in email address to reply <OakRogbak_erPine_at_yahoo.com>
Date: 18 Sep 2003 13:46:04 -0700
Message-ID: <13fdc9b4.0309181246.4440c3d@posting.google.com>


I don't know if we need it or not. I wouldn't even know how to set it. This is something that is being done automatically. Oh well, I'll leave it alone for now until I can get more knowledge on it. Thanks,
Roger

>
> If you need that isolation level, there is little you can do about it.
> If you don't need it, try to use the default instead and you could get rid
> of the statement.
>
> The statement it self might not be resource heavy but more importantly, this
> probably indicates that you are creating a lot of new connections and dropping
> them after only a few statements, which can take up a lot of resources. Try to
> use some form of connection pooling if possible.
>
> /Erik
Received on Thu Sep 18 2003 - 15:46:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US