Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: who is using sort space?

Re: who is using sort space?

From: Phil Cook <pcook_at_iamerica.net>
Date: 1997/08/08
Message-ID: <01bca3a0$9e8f0840$92f9adcd@phil-cook-laptp>#1/1 







Look in all_tables where tablespace = 'TEMP'



Phil Cook



Scott Overby <scott.overby_at_sdsdata.com> wrote in article
<01bca377$22e37920$af0ba8c0_at_pc240smo.mbo.sds.intra>...


> Is there anyway of determining what user is using up

> TEMP tablespace by large order by's?

> 

 
Received on Fri Aug 08 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US