Thursday, July 26, 2012

SQLs for collecting Session Info


select * from v$session

SELECT username,
  sid,
  serial#,
  process,
  status
FROM v$session
WHERE username IS NOT NULL


SELECT username
  ||'('
  ||sid
  ||','
  ||serial#
  ||')' username,
  module,
  action,
  client_info
FROM v$session
WHERE module
  ||action
  ||client_info IS NOT NULL;

No comments:

Post a Comment