SQL ScriptSort Usage |
Script reports sort statistics.
None.
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
Home
|
Company Profile
|
Services
|
Contact Us
|
SQL scripts and tips
|
Quiz
|