Look at Managing Resources with Profiles, 8i Admin Guide chapter 23:
http://technet.oracle.com/doc/server.815/a67772/users.htm#1148
> Gautam_Reddy_at_Dell.com wrote:
>
> Hi All,
>
> We have 8.1.6 database on an NT server and we have webserver which
> accesses database. Due to some problems with the application on the
> webserver we have to bounce it once a week. When we bounce the
> connections to the database are still existing with the
> database forever. Over a period of time this connections pile up. Has
> anyone see this behavior. When we talked to oracle support they
> suggested us to put the sqlnet.timeout parameter to timeout the
> session. This would be a big overhead on the already exhausted system.
>
> Any pointers on how this could be resolved would be appreciated.
>
Received on Mon Jul 31 2000 - 18:54:12 CDT
