select a.tablespace,a.contents,a.extents,a.blocks,b.username,b.osuser,
b.sid,sysdate
from v$sort_usage a, v$session b
where a.session_addr = b.saddr
order by extents desc

----- Original Message -----
From: "Grant, Scott" <Scott.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, December 03, 2003 1:30 PM
Subject: "Temp low (<70% left/user> 400 meg)"


Does anyone have a quick script that can identify the user that is taking
up a large amount of space in a temp segment?
maybe something using v$tempseq_usage with v$session or v$sqlarea??

im running 9.2
i have a shell script that prints out when temp segment
is being overrun by a single user.

********************************************************************
***** Temp low (<70% left/user> 400 meg) Report- 031203 1015 *
**** *
**** Temp space is running low, or there is a user who is taking *
**** quite A lot of space. See v for more info. *
********************************************************************



--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page