Re: Identifying "my" session in V$SESSION

From: Thomas Dwyer III <>
Date: 23 Dec 1993 12:04:10 -0500
Message-ID: <2fcj2a$>

David Trahan ( wrote:
>- Is there are better way to determine the relationship between
>"current" session and V$SESSION?

This is not an answer, but I have a similar question. I created profiles for my database users which limit their idle time to 2 hours. This works fine, however V$SESSION still shows the connection until the user attempts another SQL command. How can I tell which of the V$SESSION rows are really connected and which have been terminated due to profile limits? In any case, V$LICENSE always seems to show the correct number of sessions at any given time.

Tom.III Received on Thu Dec 23 1993 - 18:04:10 CET

Original text of this message