Last-Activity

Display all Oracle users by the time since last user activity Identify idle user sessions and their inactive duration for resource optimization, performance tuning, and security best practices. SQL Code 1set lines 100 pages 999 2select username 3, floor(last_call_et / 60) "Minutes" 4, status 5from v$session 6where …