sessions

Show all the Oracle users connected to the database Purpose A user calls and says the application has been slow since lunch. You need to know who is connected to the database right now, which sessions are working, and which ones are only holding a connection open. A short query against V$SESSION answers all three …