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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: direct path read/write temp waits

Re: direct path read/write temp waits

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Fri, 27 Apr 2007 09:32:26 +1100
Message-ID: <49d668000704261532me261833xde9c1472e24f872b@mail.gmail.com>


It's all in the v$tempseg_usage (=v$sort_usage),

I thought you was probably looking for select * from v$tempseg_usage where segtype='SORT'...

On 4/27/07, genegurevich_at_discoverfinancial.com <genegurevich_at_discoverfinancial.com> wrote:
> Alex,
>
> How do I do that? I couldn't see any v$ table that has information about
> has segments
>
> thank you
>
> Gene Gurevich
>
>

-- 
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 26 2007 - 17:32:26 CDT

Original text of this message

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