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: 9ias Release 2 / 9.2.0.4 Sessions

Re: 9ias Release 2 / 9.2.0.4 Sessions

From: Ed_Zep <edward.mcmonagle_at_ntu.ac.uk>
Date: 20 Aug 2004 15:25:55 -0700
Message-ID: <4e489625.0408201425.28e05b24@posting.google.com>


Hi Yong,

thanks very much for replying.
It is indeed about capacity planning. I was just wondering about which configuration settings we'd have to change to make sure that only the appropriate number of DB sessions were opened as a result? Does 9ias tune that itself or is it configurable?

Best regards,

Ed.

yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0408200700.6f5198ec_at_posting.google.com>...
> edward.mcmonagle_at_ntu.ac.uk (Ed_Zep) wrote in message news:<4e489625.0408190638.53126c64_at_posting.google.com>...
> > Hi.
> >
> > We have two 9ias boxes connecting to a 9.2.0.4 database.
> >
> > On the database server, max processes on the box is set to be 230. Of
> > those processes, we normally get about 160 people logged in. About 20
> > of those are processes opened by the two 9ias boxes.
> >
> > Can someone please tell me how the amount of sessions they open in the
> > database is set and how we determine what it should be.
>
> HI, Ed,
>
> I think your question is about capacity planning. To determine how
> many sessions are opened with one user using the 9iAS, you can open a
> 9iAS session (login 9iAS portal, forms, or whatever you have), then
> immediately run select * from v$session where logon_time > sysdate -
> 1/288 in the database. That gives you the sessions just opened in the
> past 5 minutes. Play around and you'll find some hints to identify
> those sessions unique to 9iAS. For instance, if all you use is 9i
> Forms service, you'll see sessions whose
> v$session.program='ifweb90.exe'. Assuming one user opens 3 DB forms at
> the same time on average and your database runs in dedicated
> configuration, the total number of new sessions is about 3 times the
> expected concurrent users. If you use other services in 9iAS, then do
> some experiment, identify them and add them up.
>
> Let me know if that's what you're asking for.
>
> Yong Huang
Received on Fri Aug 20 2004 - 17:25:55 CDT

Original text of this message

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