Re: Weblogic 5.1, JDriver for Oracle and logons cumulative

Hi,

yes, WebLogic is the only application. SQL/PLUS adds the number of cumulative log/ins, but not the amount I am experiencing. I assume one sqlplus session consumes only one logon?

I have two applications running on the same WebLogic instance. Both have the same application code and similar settings for connection pool. Only difference is that they connect to different Oracle instance. The other one continually grows the number of logons while the other keeps it constant. It seems that there is something about the Oracle configuration which triggers this behaviour.

> Hi. Is weblogic the only application connecting to the DBMS? Would not a
> new sesssion from SQL-PLUS also bump the number of cumulative
> log-ins? How is your pool defined? Are you alowing shrinking? If so,
> the pool will continually close unneeded connections, and remake them during
> peak loads. If your pool's initial capacity and max capacity are the same
> (which we recommend for performance and stability), then weblogic will
> make all the connections it will ever need at startup, and won't make any more
> unless the pool is reset, or the DBMS cycles.
> Joe
>
> janne wrote:
>
> > Hi,
> >
> > I'm running WebLogic 5.1sp12 (Solaris), Oracle 8.1.7 and JDriver
> > oci817_8 drivers. WebLogic and application code is configured to use
> > connection pool. Now, when running application, Oracle statistic
> > "cumulative logons" seems to grow constantly. Am I correct to think
> > that this shows a problem with the connection pool? If connection pool
> > is working, and has reached it's maximum size, shouldn't the number of
> > logons stay constant?
> >
> > SQL> select * from V$SYSSTAT where STATISTIC# IN (0, 1);
> >
> > STATISTIC# NAME
> > ---------- ----------------------------------------------------------------
> > CLASS VALUE
> > ---------- ----------
> > 0 logons cumulative
> > 1 281595
> >
> > 1 logons current
> > 1 14
> >
> > ...after a few moments:
> >
> > SQL> select * from V$SYSSTAT where STATISTIC# IN (0, 1);
> >
> > STATISTIC# NAME
> > ---------- ----------------------------------------------------------------
> > CLASS VALUE
> > ---------- ----------
> > 0 logons cumulative
> > 1 281603
> >
> > 1 logons current
> > 1 14
> >
> > --Janne.
Received on Wed Oct 16 2002 - 01:43:03 CDT