The following will discuss the information that can be gathered regarding a specific session. .
The main location for all session information is the v$session view.
The sessions.sql script displays session information using this view along with the v$process, v$sesstat, and v$statname views.
The v$process view provides information about the background processes that service the sessions,
while the v$sesstat and v$statname provide statistical information about the session.
select a.username, a.osuser, a.sid, a.SERIAL# , d.spid,

Recent comments
1 day 16 hours ago
1 day 17 hours ago
3 weeks 5 days ago
4 weeks 4 days ago
7 weeks 1 day ago
10 weeks 4 days ago
10 weeks 5 days ago
11 weeks 18 hours ago
11 weeks 1 day ago
11 weeks 1 day ago