DBA's
Other than the Idle Timeout setting in Profiles is there any
other setting that will set session status to SNIPED? We are having
problems with application Sessions not terminating - inactive sessions
over 28 hrs old and a few SNIPED sessions. To resolved the number of
Inactive sessions accumulating and exceeding the MAX Process number we
created a profile for this DB user with a IDLE Timeout of 2 hours - this
resulted in many SNIPED sessions that had to be manually cleared. So we
went back to the default profile (unlimited) this resolved most of the
SNIPED sessions but not all. In talking with the developers, they
mentioned that their application was tested on a Vanilla (default)
Oracle 9i (9.2.0.4) DB and that any session parameter setting other than
the default might be causing the connection release call to fail causing
these "Orphaned" sessions?

Thanks,

MB

Oracle LazyDBA home page