Oracle

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,

Toad Using Oracle Instant Client

At the beginning I would like to say that I don't know ORACLE, but I guess I'm a good googler.

I tried to make Toad worx using Oracle client but I didn't find Oracle client for Windows (32 bit).

Powered by Drupal - Design by artinet