Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance impact of inactive sessions
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 DBAReceived on Fri Jan 19 2007 - 04:42:58 CST