Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Weblogic 5.1, JDriver for Oracle and logons cumulative
Joseph Weinstein <joe_at_bea.com.remove.this> wrote in message news:<3DB02C9C.8552669B_at_bea.com.remove.this>...
> janne wrote:
>
> > ...and it seems that refreshTestMinutes has no effect on the count(*)
> > from dual. It is always executed for each page request (each time a
> > connection is requested from connection pool?).
>
> If you have testConnsOnReserve=true, the pool will issue that query to the test table
> to verify the connection is good before giving it to your application code, so you will see
> one such query for each time your application reserves a pool connection. Unless this
> query fails, the pool won't be making any new connections. The JDBC log would show
> weblogic makng new connections.
Finally found the answer to this. Logons cumulative started acting normally when I changed Oracle parameter
job_queue_processes = 4
to
job_queue_processes = 0
I have no idea why this happens. Received on Tue Oct 22 2002 - 01:42:50 CDT