Finding the time of the last transaction

Use the following to find when the last transaction occured for a particular session.

to_char(sysdate - (last_call_et) / 86400, 'dd-mon-yyyy HH24:MI:SS')

last_call_et is found in v$session. 86, 400 refers to the number of seconds in a given day.

Therefore if the last_call_etl gives a time of 1000, this equates to 0.0116 of a day, then by including sysdate in a function gives you the date of the last activity by the session.

A value of '0', of course means that this session is working away.