The time session has been idle can be determined from V$SESSION.LAST_CALL_ET. It shows the time (in seconds) since the session has isued its last call to the database.