Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 18th, 2005, 06:51 AM
Registered User
Join Date: Dec 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default last activity time of a oracle session

Oracle 9i.

OEM can show (session per session) the timestamp, each session issued its last activity.

How can I know that (last timestamp session activity) using simple SQL statement?
Old April 11th, 2006, 02:04 PM
Registered User
Join Date: Apr 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

In 8i:
select to_char(sysdate - last_call_et / 86400,'HH24:MI') from v$session

See if it works in 9i, 10g and post back

Similar Threads
Thread Thread Starter Forum Replies Last Post
session time out info nasirmunir PHP How-To 1 August 22nd, 2008 03:07 PM
session time out problem jaya929 ASP.NET 2.0 Professional 2 July 9th, 2008 02:15 AM
Session time out issue sameer_chandra Pro VB 6 1 July 31st, 2006 11:29 AM
session time out lily611 General .NET 10 August 9th, 2004 08:51 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.