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....@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
>
