Re: direct path read/write temp waits

From: <genegurevich_at_discoverfinancial.com>
Date: Fri, 27 Apr 2007 11:53:10 -0500
Message-ID: <OF05C7BC42.22261C21-ON862572CA.005CB3F5-862572CA.005CC113@discoverfinancial.com>

So far I am only seeing the SORT segments. I'll keep checking while the process is running

thank you

Gene Gurevich

                                                                           
             "Alexander                                                    
             Fatkulin"                                                     
             <afatkulin_at_gmail.                                          To 
             com>                      "genegurevich_at_discoverfinancial.com 
             Sent by:                  "                                   
             oracle-l-bounce_at_f         <genegurevich_at_discoverfinancial.com 
             reelists.org              >                                   
                                                                        cc 
                                       oracle-l_at_freelists.org              
             04/26/2007 05:32                                      Subject 
             PM                        Re: direct path read/write temp     
                                       waits                               
                                                                           
             Please respond to                                             
             afatkulin_at_gmail.c                                             
                    om

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






--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 27 2007 - 11:53:10 CDT