Re: 9ias Release 2 / 9.2.0.4 Sessions

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 - 10:00:30 CDT