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: Giorgos Tsiamitas <gtsiam_at_gmx.net>
Date: Fri, 18 May 2001 09:11:02 GMT
Message-ID: <GG5N6.41$6f3.1298@nreader1.kpnqwest.net> 






select sum(bytes) from dba_segments where segment_type='TEMPORARY'


--
Giorgos

"Bob" <no-one_at_localhost.com> wrote in message
news:3B04844E.A7894D73_at_localhost.com...


> 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 - 04:11:02 CDT












Original text of this message













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