Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using V$session to Find Old Connections

632013Mar 23 2009 — edited Mar 23 2009
hi experts,

In my 10.2 database, when I select from the V$session view, it returns a column named 'LOGON_TIME'. In my database, it does not contain a time - just 23-Mar-09 for example. I assume this is just what the name says - it is the date the session began.

Is there a way of finding sessions that have had no activity for several hours/days? I have learned that the STATUS column is not really any use to me.

Thanks, 10g on Windows.

John
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2009
Added on Mar 23 2009
#general-database-discussions
4 comments
4,198 views