Title: RE: Middle Tier spawning sessions, possible performance issues
Anjo,
Actually I saw this in your (et al) famous YAPP
paper.
Still
curious,
Steve
-Original Message-From: Orr, Steve Sent:
Thursday, January 30, 2003 10:32 AMTo: Multiple recipients of list
ORACLE
R - I haven't yet been the victim of .net (thankfully), and I hope someone
with direct experience will reply. But just in case, I'll mention a couple
of ideas.
Try to sample the SQL that is being inflicted on Oracle. Microsoft
interfaces tend to have default settings for the lowest common
I'm far more of a developer than a DBA, but when someone told me this it set off a big
red light in my head.
We are using an Oracle Backend with a .net front front. One of our .net guys told me
that the middle tier they are using 'spawns' sessions.
We have 2 pretty distinct skillsets here so
250 connections from the middle tier does sound a bit suspect, way over the
top. I'm assuming 'spawns' relates to establishing connections as and when
required and then disconnecting when done. I think you will find that there
is quite an Oracle overhead in handling all of the connect/disconnect
You are kind of on the right track. The number of sessions doesn't really
matter. What matters is that they logon/logoff all the time. That is the
worst thing that you can do in an Oracle database. Why? The session will
allocate the cursors, parse them, close them everytime the session will
Title: RE: Middle Tier spawning sessions, possible performance issues
I read somewhere that for apps that constantly logon/logoff (like web apps), one possible thing to do is increase the cache size for the AUDSES$ sequence. Anyone done this and seen improvements?
Curiously,
Steve Orr
Title: RE: Middle Tier spawning sessions, possible performance issues
Any
takers on this ??
-Original Message-From: Orr, Steve Sent:
Thursday, January 30, 2003 10:32 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Middle Tier spawning sessions, possible