Session status SNIPED

From: Mario <mtechera_at_wpmc.com>
Date: 25 Sep 2001 08:49:16 -0700
Message-ID: <65c992b1.0109250749.4728a66a@posting.google.com>

Hello Everyone:

In monitoring sessions, Oracle sets sessions to SNIPED when they have used up their idle time quota assigned to the user's profile.

The Oracle documentations defines SNIPED as: "session inactive, waiting on the client"

I am administering a large intranet application and this happens VERY often and I get literally dozens of sniped sessions. At some point Oracle decides to clean them up and they disappear.

What exactly is responsible for cleaning up the SNIPED sessions? Is there any way to set the clean-up process frequency?

Regards to all,
MT Received on Tue Sep 25 2001 - 10:49:16 CDT