Originally posted by raghud
A session will continue to show as idle even after the idle_time for that user, as specified in that user's profile, has expired. When the user attempts to run a transaction against the database after the idle_time has expired, the database will disconnect the user by terminating the session. After this, the session will no longer show in the output of the above query.
Bravo! raghud is a true believer in the quest for knowlege. Now that samdba has his answer, we can all rest.