ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DelGurth <delgu...@gmail.com>
Subject Re: Oracle v$session and iBatis
Date Wed, 29 Apr 2009 13:07:04 GMT
I'm just wondering, how exactly are are monitoring the connections
using v$session? Since 27/28 sessions already seems to be way more
then what you configured: <property
name="Pool.MaximumActiveConnections" value="10"/>

Do you filter for the user that you configured and checking the
active/inactive status of the session?

Wessel

On Wed, Apr 29, 2009 at 1:18 PM, Leffingwell, Jonathan R CTR FRCSE,
JAX 7.2.2 <jonathan.leffingwell.ctr@navy.mil> wrote:
> Hey, thanks for the TONS of helpful replies I got to this question!  It's a
> good thing this wasn't to solve an enterprise question or anything.  Oh,
> wait...it was.
>
> Signing off...
>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Oracle v$session and iBatis
> Leffingwell, Jonathan R CTR FRCSE, JAX 7.2.2
> Tue, 14 Apr 2009 07:03:18 -0700
>
> We are monitoring our web app through, among other things, looking at the
> Oracle view v$session.  For testing purposes, we tested one user logging
> into the system, doing a couple of transactions, then logging out.  The
> number of "connections" (for lack of a better term) in v$session fluctuated
> greatly, and when the user logged out of the application, the number of
> "connections" went from 27...to 28!  Does it make sense for a user to log
> out and INCREASE the number of connections?
>
> Here's how my transaction manager is configured:
>
> <sqlMapConfig>
>  <settings
>    cacheModelsEnabled="false"
>    enhancementEnabled="false"
>        lazyLoadingEnabled="false"
>    maxSessions="64"
>    maxTransactions="32"
>    maxRequests="512"/>
>
>  <transactionManager type="JDBC">
>    <dataSource type="SIMPLE">
>                <property name="DataSource" value="${datasource}"/>
>                <property name="JDBC.Driver" value="${driver}"/>
>            <property name="JDBC.ConnectionURL" value="${url}"/>
>                <property name="JDBC.Username" value="${username}"/>
>                <property name="JDBC.Password" value="${password}"/>
>                <property name="JDBC.DefaultAutoCommit"
> value="$(autocommit)"/>
>                <property name="Pool.MaximumActiveConnections" value="10"/>
> <!-- Default = 10 -->
>                <property name="Pool.MaximumIdleConnections" value="5"/>
> <!-- Default = 5  -->
>                <property name="Pool.MaximumCheckoutTime" value="20000"/>
> <!-- Default = 20000 milliseconds  -->
>                <property name="Pool.TimeToWait" value="20000"/>
> <!-- Default = 20000 milliseconds  -->
>                <property name="Pool.PingEnabled" value="true"/>
> <!-- Default = false  -->
>                <property name="Pool.PingQuery" value="select 0 from dual"/>
> <!-- No Default Query  -->
>                <property name="Pool.PingConnectionsOlderThan"
> value="7200000"/>               <!-- Default = 0 milliseconds  -->
>                <property name="Pool.PingConnectionsNotUsedFor"
> value="7200000"/>               <!-- No Default  -->
>    </dataSource>
>  </transactionManager>
>
>  <sqlMap resource="folder/sql/ourSQL.xml"/>
>
> </sqlMapConfig>
>
> Can anyone tell me how connections are handled in a simple datasource in
> iBatis, with respect to the v$session view?  Is connection pooling not
> happening?  Any insight would be appreciated, and my apologies in advance if
> I'm not clear.
>
> Jonathan
>

Mime
View raw message