Re: 9ias Release 2 / 9.2.0.4 Sessions

[moved your reply to the end]
edward.mcmonagle_at_ntu.ac.uk (Ed_Zep) wrote in message news:<4e489625.0408201425.28e05b24_at_posting.google.com>...
>
> 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

Ed,

Let's talk about 9iAS Release 2. Depending on what components you use, you can configure mod_plsql or OC4J connection pooling to save database connections.

To configure mod_plsql pooling, add PlsqlMaxRequestsPerSession and possibly a few other parameters to $OH/Apache/modplsql/conf/dads.conf as described at
http://download-east.oracle.com/docs/cd/A97329_03/web.902/a92173/confmods.htm#1018033

To configure OC4J connection pooling, consider these Connection Attributes in EM:
Maximum Open Connections
Minimum Open Connections
Wait For Free Connection Timeout(secs)
as described at
http://download-east.oracle.com/docs/cd/A97329_03/web.902/a95880/dsprimer.htm#1006965 That adds the entries max-connections, min-connections and wait-timeout, respectively, to $OH/j2ee/<OC4J instance>/config/data-sources.xml.
More info about Data Sources is at
http://download-east.oracle.com/docs/cd/A97329_03/web.902/a95879/ds.htm

Let me know if that answers your question.

Yong Huang Received on Mon Aug 23 2004 - 13:50:34 CDT