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: Performance impact of inactive sessions

Re: Performance impact of inactive sessions

From: sybrandb <sybrandb_at_gmail.com>
Date: 19 Jan 2007 02:42:58 -0800
Message-ID: <1169203378.161717.253290@q2g2000cwa.googlegroups.com>

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
Received on Fri Jan 19 2007 - 04:42:58 CST

Original text of this message

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