“Sessions” Information


SELECT * FROM v$session where status='ACTIVE';
SELECT v$session.sid,
 spid,
 v$session.username,
 status,
 v$session.machine,
 v$session.program,
 v$session.event,v$session.sql_id,
 sql_text
 FROM v$session, v$process, v$sql
WHERE v$process.addr = v$session.paddr
 AND v$session.sql_id = v$sql.sql_id(+)
and v$process.spid=44689 /* and v$session.sid=16449 */;

SELECT * FROM v$session, v$process, v$sql
WHERE v$process.addr = v$session.paddr
 AND v$session.sql_id = v$sql.sql_id(+)
and /* v$process.spid=3058 and */ v$session.sid=32733;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: