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: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 19 May 2001 07:31:09 +0100
Message-ID: <990253688.18270.0.nnrp-08.9e984b29@news.demon.co.uk>

Also v$sort_usage shows (depending on Oracle versions who is using how much of each segment and what they are using it for)

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



bhom_at_sprintmail.com wrote in message <3B05B40C.5C59EF91_at_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 Sat May 19 2001 - 01:31:09 CDT

Original text of this message

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