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
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