Mohammad Nazmul Huda
Search this site
About Me
Certifications
Employment History
Publications
Study Resources
Training
Technical Docs
Oracle
Managing Database
Backup and Recovery
Performance Tuning
ASM
Security
Replication
Database Change
Data Guard
Cloud Control
LISTENER
Parameters
SQL
SQL Functions
PL/SQL
ORA ERROR
12c Issues
Bugs
Scripts
Tools
OCM
Teradata
MySQL
SQL SERVER
Linux
AWS
Data Science
Other
Contact
Check inactive or idle session
select username, UPPER(program), logon_time,
floor(last_call_et / 60) "Minutes since active", status
from v$session
order by last_call_et;
Comments