Re: Performance impact of inactive sessions

EdStevens wrote:
> Martin T. wrote:
> > EdStevens wrote:
> > > sybrandb wrote:
> > > > On Jan 19, 10:00 am, "Jack" <n..._at_INVALIDmail.com> wrote:
> > > > > Shortly: Nope
> > > > >
> > > > > "Martin T." <bilbothebagginsb..._at_freenet.de> wrote in messagenews:1169195643.040984.149850_at_v45g2000cwv.googlegroups.com...
> > > > >
> > > > >
> > > > >
> > > > > > Greetings!
> > > > >
> > > > > > Please bear with me if I'm being somewhat unspecific here, but I yet
> > > > > > don't know enough to get more specific:
> > > > >
> > > > > > I will make it short for this initial question: Would you expect a
> > > > > > problematic performance impact on a Oracle 9i2 database by lots (say 30
> > > > > > on a decent modern workstation PC) of INACTIVE sessions versus a system
> > > > > > where the number of active processing (say 4-5 active sessions) is the
> > > > > > same without these inactive sessions?
> > > > >
> > > > > > thank you,
> > > > > > br,
> > > > > > Martin- Hide quoted text -- Show quoted text -
> > > >
> > > >
> > > > Disagree.
> > > > Inactive sessions don't release their memory.
> > > >
> > > > --
> > > > Sybrand Bakker
> > > > Senior Oracle DBA
> > >
> > > True, but they also don't consume any CPU or I/O. The only way I could
> > > see an inactive session impacting performance would be if the memory
> > > consumption forced additional OS paging. And even at that, once the
> > > memory for the inactive session is paged out, it should pretty much be
> > > out of the picture until such time as it 'goes active' and has to be
> > > paged in.
> > >
> > > I guess it comes back to .. if you have a performance issue, identify
> > > the actual bottleneck and address the issue.
> >
> >
> > Thanks all for the replies.
> >
> > And yes, this post was part of the search for the bottleneck. (Because
> > we have not the tiniest clue at the moment as to where that might be
> > :-/ )
> >
> > br,
> > Martin

>

Hee, hee. Just found about statspack yesterday. :-| Did a report and I'm currently trying to figure it out. (Asked a colleague here if he knew how to read such a report, but he's worked with Oracle for the last 5 years and never user such a thing (didn't know what it is) ... there you go. Me, I never wondered why we had problems with the DB ... just trying (and up to now failing 1/2 the time) to fix things ...)

cheers,
Martin Received on Sat Jan 20 2007 - 07:40:31 CST