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 -> Ownership of Temp Segments

Ownership of Temp Segments

From: Dennis Flinn <dflinn_at_eastman.com>
Date: Tue, 01 Jun 1999 14:01:38 -0400
Message-ID: <37542002.F870876A@eastman.com> 





I was wondering if anyone knew how to tell who is using segments in
temporary tablespace.  We are running primarily Oracle v7.3.x but the
question also applies to Oracle 8.x.  We can see segment being used in
the temporary tablespace, but would like to find out who is using them. 
We have looked at dba_segments but the owner always appears to be SYS.



Thanks,


Dennis
Received on Tue Jun 01 1999 - 13:01:38 CDT












Original text of this message













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