Hi, I am trying to find out if there is a way to find out at which point in time a particular session from the application (connection pool) has become active (Querying the Database) and how long is that particular session or session ID has been active and idle? I was doing my own research and found a little info from v$session and DBA_Active_Session_History
The following gets me the no.of sessions made to the DB per hour
( select sysdate,
TRUNC(logon_time,''HH''),
COUNT(*) NO_OF_SESSIONS,
username
from v$session
where username IS NOT NULL
GROUP BY TRUNC(logon_time,''HH''),
USERNAME
)
But, What i am looking for is
Connection_Established_Time Last_Active Last_Idle_Since
Thanks In Advance