Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Who is sorting
Does anybody know if there is a way to find out who
is taking up the temporary segments for sorting ?
We have had several experiences that temporary tablespace got used up. But all you can find out from dba_segments are the temp segment ID and owner SYS. I really like to locate the SID associated with that.
Thanks for any advice in advance.
-Bass Chorng
DBA
Lucent Technologies
Received on Tue Dec 08 1998 - 14:47:53 CST