SQL Script Sort Usage

Updated: 08-Jan-2002
Version: 1.0

Description

Script reports sort statistics

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

col username form a10 heading "DB User"
col osuser form a10 heading "OS User"
col name form a20 heading "Type Of Sort"
col tablespace form a10

SELECT s.username
	, s.sid
	, s.serial#
	, u.tablespace
	, u.contents
	, u.segtype
	, u.extents
	, u.blocks
FROM v$session s, v$sort_usage u
WHERE s.saddr = u.session_addr ;

SELECT  s.sid 
        ,s.username
        ,s.osuser
        ,vsn.name
        ,vss.value
FROM    v$session s,
        v$sesstat vss,
        v$statname vsn
WHERE   vss.statistic#=vsn.statistic#
AND     s.sid = vss.sid
AND     vsn.name like '%sort%'
AND     s.username is not null
ORDER BY s.username
/

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links