CoderZone.org

Category: >> Oracle PL/SQL >> DBA Sessions Bookmark and Share

<< lastnext >>

Snippet Name: DBA Sessions

Description: Returns a list of users and their session details.

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile info...
» Find users with deadly privileges
» Audit User Logins (User Login Trig...
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files
» DBA Extents

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 01st, 2009

SET linesize 170
SET pagesize 60
break ON osuser skip 1
spool sessions.lst
SELECT SUBSTR(v$session.username,1,15),
       v$session.process,v$session.sid,
       v$session.serial#,
       SUBSTR(v$session.program,1,23),v$session.status,
       v$session.terminal,
       SUBSTR(v$statname.name,1,30),
ROUND(((v$timer.hsecs - v$sesstat.VALUE)/100/60/60),2) HOURS
FROM v$timer,v$statname,v$sesstat,v$session
WHERE v$statname.statistic# = v$sesstat.statistic# AND
      v$sesstat.statistic# IN (13,14) AND
      v$sesstat.sid = v$session.sid
ORDER BY v$session.username,v$session.sid,v$sesstat.statistic#
/
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 10