Oracle Sessions Monitoring

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,

Powered by Drupal - Design by artinet