Created a little admin app to do just that, and it worked perfectly.
All the connections being shown as "busy" cleared right out, and only
the minimum number of idle / available connections remained.

Thanks much.

On 1/10/07, Varley, Roger <Roger.Varley@(protected):
>
> >
> > I agree that is probably what is happening, since the application has
> > gone idle. However, with garbage collection, while it will only
> > reclaim memory when necessary, there is a way to force garbage
> > collection. I am looking for a similar process with abandoned
> > database connections.
> >
>
> If the connections will only re-cycle with increased demand, could you not create that demand with an "admin" type program that requests, opens & then closes X connections?
>
> Regards
> Roger
>
> _______________________________________________________
>
> This e-mail and the documents attached are confidential and intended
> solely for the addressee; it may also be privileged. If you receive this
> e-mail in error, please notify the sender immediately and destroy it.
> As its integrity cannot be secured on the Internet, the Atos Origin group
> liability cannot be triggered for the message content. Although the
> sender endeavours to maintain a computer virus-free network, the
> sender does not warrant that this transmission is virus-free and will
> not be liable for any damages resulting from any virus transmitted.
> _______________________________________________________
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@(protected)
> To unsubscribe, e-mail: users-unsubscribe@(protected)
> For additional commands, e-mail: users-help@(protected)
>
>

---------------------------------------------------------------------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)