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: Temporary segments question

Re: Temporary segments question

From: <bhom_at_sprintmail.com>
Date: Fri, 18 May 2001 23:53:48 GMT
Message-ID: <3B05B40C.5C59EF91@sprintmail.com> 






Hi,



If you've already allocated temporary segments and your temporary
tablespace is defined as "temporary", you can look at v$sort_segment.



HTH


Bob wrote:



> Simple question, I think.  I'm sure there must be a dba_ view to let me

> see how much storage is allocated to temporary segments, but I can't

> find it.  Can someone help?

>

> Thanks,

>

> Frank

Received on Fri May 18 2001 - 18:53:48 CDT












Original text of this message













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